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
 SSIS and Import/Export (2005)
 How to create a job around a stored procedure in S

Author  Topic 

pras2007
Posting Yak Master

216 Posts

Posted - 2009-05-14 : 12:42:05
Hello All,

I have a stored procedure that I want to automate to execute at a specific time every day, does anybody know how to create a job around this stored procedure in SQL Server 2005? Please advice. Thanks.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-05-14 : 13:11:56
Use SQL Server Agent
set-up a TSQL step to call your procedure
Go to Top of Page
   

- Advertisement -