如何每小时在sqlserver中运行一个存储过程?-Howtorunastoredprocedureinsqlservereveryhour?

59  

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

在SSMS中导航到SQL Server Agent——>Jobs右键单击Job文件夹并选择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

在弹出的对话框中，给作业一个名称，单击步骤，然后在new中，您将看到如下的对话框，选择正确的DB并键入您的proc名称

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

点击日程表后，选择new，你会看到如下图片，填满所有你需要的东西，点击ok，点击作业上的ok，你应该被设置

3  

1) Use the SQL Server Agent (open MS Management Studio) 2) New Job 3) Add Step 4) Choose Transact SQL 5) EXEC MyStroredProc 6) Choose database 7) Add schedule 8) Occurs every hour

1)使用SQL Server Agent (open MS Management Studio) 2)新工作3)Add Step 4)选择Transact SQL 5) EXEC MyStroredProc 6)选择数据库7)每小时发生一次。

Add notification to know that process is doing well (or bad).

添加通知，以了解进程运行良好(或坏)。

In the properties of SQL Server Agent check that all Auto restart options are switch ON

在SQL Server代理的属性中，检查所有自动重启选项是否都已打开

1  

Set up a SQL Server agent job to execute the stored procedure at 1 hour intervals

设置一个SQL Server代理作业，以每隔1小时执行存储过程