Sql server代理作业 - 即使按顺序调度，所有步骤也会同时开始 [英] Sql server Agent job - All steps are starting at the same time even they are scheduled in sequence

问题描述

我有一个sql server agent作业，它有3个步骤。所有都是Transact-SQL脚本（T-SQL）类型。 

I have a sql server agent job which has 3 steps. All are Transact-SQL script (T-SQL) type. 

在步骤1中，我已设置成功后转到下一步并在失败时退出，同样在步骤2到步骤3但不知何故所有步骤同时开始。不知道为什么？

On step 1, I have set that Go to next step on success and quit on failure, same on Step 2 to Step 3 but somehow all steps are kicking off at the same time. not sure why?

有人可以帮我吗？

提前谢谢

推荐答案

Hello  RanPr， 

Hello RanPr, 

你的意思是每一步的工作历史中显示的时间是相同的吗？

Do you mean the time shown in Job History for each step is the same?

由于时间只精确到秒，如果每一步的持续时间远小于一秒，你可以错误地认为所有步骤同时开始。 

Since the time is only accurate to second, if duration for each step is much less that one second, you may mistakenly think that all the steps start at the same time. 

如果这没有帮助，请分享作业的示例脚本（没有敏感信息），以便我们可以重现问题。 

If this doesn't help, please share the sample script(without sensitive information) of the job, so that we can reproduce the problem. 

这篇关于Sql server代理作业 - 即使按顺序调度，所有步骤也会同时开始的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！