Hi friend!
I want to schedule a query or procedure running at regular intervals eg.@. 12AM on everyday. Please help me to do this in SQL server 2005
Thanks/Regards
Antony S
There are 3 choices I can think of off the top of my head;
1/ Use SQL Agent (not available in express) and create a T-SQL job.
2/ Use the windows task scheduler to call SQLCMD and then have it call a .sql file with your code in it.
3/ Use a service broker timer.
|||Books online reference http://msdn2.microsoft.com/en-us/library/ms191439.aspx|||Create a SQL Job and a schedule inside of the job to run everyday at 12am. Make sure that SQLAgent is enabled.sql
No comments:
Post a Comment