I am using SQL Server 2005.
我正在使用SQL Server 2005。
I have a stored procedure [say Sp_GetAllMaterialInfo], I want to put it in a scheduler that everyday this stored procedure execute on 2 P.M. daily. Please let me know the steps I have to follow to achieve in SQL Server 2005
我有一个存储过程[比如说Sp_GetAllMaterialInfo],我想把它放在一个调度程序中,每天这个存储过程在下午2点执行。日常。请告诉我在SQL Server 2005中必须遵循的步骤
Thanks in advance.
提前致谢。
3 个解决方案
#1
2
Create a sql server agent job.
创建一个sql server代理作业。
#2
1
How to schedule a job in SQL server:
如何在SQL Server中安排作业:
http://technet.microsoft.com/en-us/library/ms191439.aspx
http://technet.microsoft.com/en-us/library/ms191439.aspx
#3
1
Or if you are using Express edition the approach here might help http://www.sqldbatips.com/showarticle.asp?ID=27 (Gives an example of how to run a procedure a as scheduled task)
或者,如果您使用的是Express版本,则此处的方法可能有助于http://www.sqldbatips.com/showarticle.asp?ID=27(提供如何按计划任务运行过程的示例)
Or a free utility to achieve the same thing as SQL Agent is here (I've not used it myself) http://www.lazycoding.com/products.aspx
或者一个免费的实用工具来实现与SQL Agent相同的东西(我自己没有用过它)http://www.lazycoding.com/products.aspx
#1
2
Create a sql server agent job.
创建一个sql server代理作业。
#2
1
How to schedule a job in SQL server:
如何在SQL Server中安排作业:
http://technet.microsoft.com/en-us/library/ms191439.aspx
http://technet.microsoft.com/en-us/library/ms191439.aspx
#3
1
Or if you are using Express edition the approach here might help http://www.sqldbatips.com/showarticle.asp?ID=27 (Gives an example of how to run a procedure a as scheduled task)
或者,如果您使用的是Express版本,则此处的方法可能有助于http://www.sqldbatips.com/showarticle.asp?ID=27(提供如何按计划任务运行过程的示例)
Or a free utility to achieve the same thing as SQL Agent is here (I've not used it myself) http://www.lazycoding.com/products.aspx
或者一个免费的实用工具来实现与SQL Agent相同的东西(我自己没有用过它)http://www.lazycoding.com/products.aspx