September 4th, 2003, 01:34 AM
how to schedule execution of stored procedures daily ?
First of all can we schedule the excution of stored procedures - something like the schedulers we have to execute certain tasks at regular intervals - the same way.
IF we can then, how do we do ?
September 4th, 2003, 08:09 AM
How about creating a sql job and scheduling the job to run every xx mins.
The sql job can be created via SQL Enterprise Manager -->Management -->SQL Server agent ---> Jobs ---> new ...
September 4th, 2003, 08:13 AM
thank you. Shall try this out.