SQL Server中的作业调度 [英] Job Scheduling in SQL Server

问题描述

我在SQL Server中安排一个应该每10秒运行一次的工作，但执行包的实际时间是25秒。



我的情景是，当我在前两次安排这样的时候，包将被执行并且整个数据被加载到表（Destination）中但是当它第三次执行时，包停止在中间并且部分数据量开始加载进入表格，在Job代理中是否有任何选项，比如一旦程序包在预定时间内启动，它应该完成执行，然后即使预定的时间完成它也应该终止。

I am Scheduling a job in SQL Server which should run for every 10sec,but the actual time taken to execute the package was 25 sec.

My Scenario was,When i scheduled like this for the first 2 times the package will get execute and entire data is getting loaded into the table(Destination) but when it get executes for the 3rd time the package stops in middle and partial amount of data is begin loaded into the table,is there any option in Job agent like once the package starts with in the scheduled time, it should complete the execution and then it should terminate even if the scheduled time is completed.

推荐答案

你需要用计划时间进行一些代码更改，请加上10秒来打包执行时间

you need to make some code change with schedule time please make addition with 10 Sec to package execution time

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