How to run a stored procedure in sql server every hour?

In SSMS navigate to SQL Server Agent–>Jobs
Right click on the Job Folder and select new job

on the dialog that pops up, give the job a name
click on steps, then on new, you will see a dialog like the following, pick correct DB and type your proc name

alt text

after that click on schedule, pick new and you will see something like the image below, fill all the stuff you need and click ok, click ok on the job and you should be set
alt text

Leave a Comment