Friday, May 28, 2010

Schedule a Stored Procedure to Run in SQL Server


I needed to know how to schedule a stored procedure to run over and over! This is a brief step by step of how to get going. This isn't meant to hold your hand but get you going!

Here is a brief how-to steps!

1. Open SQL Enterprise Manager

2. Expand the database folder, Select your database if there are several 
databases

3. Left Single click on the place where it says stored procedures

4. Right click after selecting and choose new stored procedure

5. Create and save your stored procedure (Even has a syntax checker!)

6. Inside Enterprise Manager--Click on Tools, Job Scheduling (A wizard will 
appear)

7. Click Next

8 Leave Transact SQL-command selected, Click Next

9. Verify the database and in the big text box type -- EXEC 
storedprocedurename

10. Click Next

11. This will bring up a form that allow you to do whatever. Run now is 
selected. To make it a reoccurring stored proc the 5th option is that.

12. Schedule how you want the stored proc to run

13. Choose if you want to email or net send command. If you don't want 
anything click next

14. To modify or delete the job open SQL Enterprise Manager

15. Expand the Management Folder, Expand SQL Server Agent, select Jobs.

16. This is where all the info on the jobs that you created in Job 
Scheduler.


17. Right Click on the job and choose properties. That's it!


No comments:

Post a Comment