有关SQLServer的帮助 [英] help about SQLServer

问题描述

嘿用户....！
我想在特定的时间间隔内执行MS SQL的存储过程....(例如:每月1号).
Plzzzz帮助...！
在此先谢谢您. >

您可以使用SQL Server代理计划批处理作业，
有关计划作业如何在Google上冲浪并查看
的更多信息 http://www.sqlservercurry.com/2009/11/executing-stored- procedure-at-regular.html [ ^ ]
这可能对您有帮助

Hey users....!
I want to execute a stored procedure of MS SQL in a particular interval of time.... (Eg: 1st of every month).
Plzzzz Help...!
Thank in advance.

解决方案

You can add a job in Sql Server to call this procedure and set a schedule for that to be executed at the specific time.

you can use SQL Server Agent to schedule a batch job ,
for further information of how schedule jobs surf google and have a look at
http://www.sqlservercurry.com/2009/11/executing-stored-procedure-at-regular.html[^]
this might help you

这篇关于有关SQLServer的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！