How do I set up to run a stored procedure automatically every day in SQL Server 2008 R2?
如何设置在SQL Server 2008 R2中每天自动运行存储过程?
4 个解决方案
#1
4
Set up a SQL job http://msdn.microsoft.com/en-us/library/ms135739.aspx
设置一个SQL作业http://msdn.microsoft.com/en-us/library/ms135739.aspx
#2
2
You need to use the Job scheduler in the sql agent. Sql express doesn't include it so I just have a batch file run as a scheduled task to run it. -James
您需要在sql代理中使用作业调度器。Sql express不包含它，所以我只是让一个批处理文件作为计划任务运行它。——詹姆斯
#4
0
Under SQL agent you need to go to the job scheduler and create a job that runs the stored proc. Once you have created the job you can create one or more schedules for the job. http://msdn.microsoft.com/en-us/library/ms135739.aspx
在SQL代理下，您需要转到作业调度器并创建一个运行存储proc的作业。http://msdn.microsoft.com/en-us/library/ms135739.aspx
#1
4
Set up a SQL job http://msdn.microsoft.com/en-us/library/ms135739.aspx
设置一个SQL作业http://msdn.microsoft.com/en-us/library/ms135739.aspx
#2
2
You need to use the Job scheduler in the sql agent. Sql express doesn't include it so I just have a batch file run as a scheduled task to run it. -James
您需要在sql代理中使用作业调度器。Sql express不包含它，所以我只是让一个批处理文件作为计划任务运行它。——詹姆斯
#3
#4
0
Under SQL agent you need to go to the job scheduler and create a job that runs the stored proc. Once you have created the job you can create one or more schedules for the job. http://msdn.microsoft.com/en-us/library/ms135739.aspx
在SQL代理下，您需要转到作业调度器并创建一个运行存储proc的作业。http://msdn.microsoft.com/en-us/library/ms135739.aspx