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.
| Author |
Topic |
|
tariq_erp
Starting Member
9 Posts |
 Posted - 2008-06-03 : 02:13:56
|
| HI ALLI have created a stored procedure for a routine task to be performed periodically in my application. Say, i want to execute my stored procedure at 12:00 AM daily. How can I add my stored procedure to the SQL server agent jobs??Any Idea.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-03 : 02:20:30
|
| Create a new job which calls this stored procedure i.e EXEC Sp params. Then schedule this job to be executed daily at 12:00 AM. http://msdn.microsoft.com/en-us/library/ms187056.aspx |
 |
|
|
|
|
|
Running Stored Procedure using SQL server agent...