如何在sql server中运行存储过程3小时？ [英] How to run a stored procedure in sql server 3 hour?

问题描述

我有一个关于Inserflip的表，我想每3小时执行一些操作。为此，我创建了一个存储过程，但知道如何称它为3小时。我知道有一些预定的工作，但是如何使用它们。



是否还有某种服务可以持续运行，每一秒，我在哪里可以放置我要执行的代码吗？

I have a table on Inserflip which I want to perform some operations every 3 hour. For this I created a Stored Procedure but know how to call it 3hour. I know there are some kind of scheduled jobs, but how to use them.

Is there some kind of service also that keeps on running continuously, every second, where I can place my piece of code to be executed ?

推荐答案

您可以安排SQL Server代理作业来执行此操作... insctions [ ^ ]这里。



概念描述此处 [ ^ ]

You can schedule a SQL Server Agent job to do this ... instructions[^] here.

Concept described here[^]

这篇关于如何在sql server中运行存储过程3小时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！