How to schedule a stored procedure to run everyday

Hi

I have a stored procedure in Seever 2005 that i want to run everynight .

Whats the best way to do this. (? windows scheduler)

Can some one give me directions how to do it

Thanks

Generally you would use SQL Server Agent and schedule a job to run the stored procedure every night. If you are using the Express edition, you would need to use Windows Schedule as SQL Agent is not available with that edition. If you look up Jobs in Books Online, you will find information on doing this. Check the how to topics to walk you through the steps for setting up and executing jobs: http://msdn2.microsoft.com/en-us/library/ms189880.aspx

-Sue

|||

Ok i will give it a try and let you know

Thanks for your help