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 ?
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 ...