<REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote:
> "Fendi Baba" <effe...@epitome.com.sg> wrote in message
>
> news:1178257104.986617.114630@h2g2000hsg.googlegroups.com...
>
> >I am new to MS SQL. Can I write a batch job which will execute the sql
> > statement nightly?
>
> > How do I do this?
>
> sp_add_job
>
> Read about SQL Server Agent in Books Online.
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --

On 4 May, 08:17, Damien <Damien_The_Unbelie...@hotmail.com> wrote:
>
> Agent isn't available in express. I think people generally write
> scripts and then use the windows scheduler to run batch jobs on
> express.
>

"Fendi Baba" <effendi@epitome.com.sg> wrote in message
news:1178257104.986617.114630@h2g2000hsg.googlegroups.com...
>I am new to MS SQL. Can I write a batch job which will execute the sql
> statement nightly?
>
> How do I do this?
>

<REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote:
> On 4 May, 08:17, Damien <Damien_The_Unbelie...@hotmail.com> wrote:
>
>
>
> > Agent isn't available in express. I think people generally write
> > scripts and then use the windows scheduler to run batch jobs on
> > express.
>
> True. I didn't spot "Express" in the title.
>
> Service Broker CONVERSATION TIMER is another way to schedule an event
> in Express.
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --