Schedule SQL to run

[avid1741]

I am needing to schedule a series of SQL to run at a speicfic time and day. Are there any codes out there that would accomplish this task?

 

[tlbroadbent]

You can Scheudle jobs in SQL Server using the SQL Agent. Jobs can run SQL code, stored procedures, tasks, etc. SQL BOL contains details about creating and scheduling jobs.

http://msdn.microsoft.com/library/en-us/adminsql/ad_automate_7awj.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_automate_42r7.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_automate_3v5f.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_automate_1o4z.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.