Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Automate Stored Procedures

Author  Topic 

JezLisle
Posting Yak Master

132 Posts

Posted - 2009-07-09 : 03:55:55
I dont know if I have put this thread in the wrong area, I am looking to find out how I can do this below.

I want to be able to set up a procedure that when the date is the 1st of every month that a series of of Stored Procedures will run.

How can I do this, is it called Scheduling?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-09 : 04:03:36
Yes. You create the job and schedule it via SQL Agent. Run the Management Studio and you will find it there


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-09 : 04:03:40
Hi

Understanding Scheduling
http://msdn.microsoft.com/en-us/library/aa175263(SQL.80).aspx
http://msdn.microsoft.com/en-us/library/ms189267.aspx

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express-2

-------------------------
Your time is a valuable resource.
Go to Top of Page
   

- Advertisement -