在特定时间执行存储过程. [英] execute a stored procedure on a particular time.

问题描述

我将在数据库中创建一个存储过程，该过程将每天更新成员的少量活动.我想要的是该存储过程每24小时执行一次.我可以制定任何计划或类似的计划吗?

I will make a stored procedure in my database which will update members few activity on daily base. What I want is I want that stored procedure to be executed once in 24 hours. Can i make any schedule or something like that?

推荐答案

是的，您可以在SQL Server中创建计划的任务，也可以编写可以为您执行此任务的服务.

Yes, you can create a scheduled task in SQL Server, or you could write a service that does it for you.

SQL Server具有作业调度功能.您可以在此处 [ ^ ].

SQL Server has job scheduling capabilities. You can find out more about how SQL Server Agent can be used to schedule administrative tasks here[^].

这篇关于在特定时间执行存储过程.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！