设置两个sql server代理作业之间的依赖关系 [英] Setting dependency between two sql server agent jobs

问题描述

我每天都有Job 1运行，Job 2每周运行一次。但是Job 2应该在Job 1成功运行后运行。你能不能告诉我怎么做？

I have Job 1 runs daily and Job 2 runs weekly once. But Job 2 should run after Job 1 runs successfully. would you please let me know how can it be done?

提前谢谢你，

推荐答案

要么有作业1开始作业2，要使用最终作业步骤（sp_start_job），要么经常安排作业2并检查作业1的状态，如果它还不是"时间"，然后退出我会选择第一个选项。

Either have job 1 start job 2, using a final jobstep (sp_start_job), or schedule job 2 frequently and check the status of job 1, if it isn't "time yet", then just exit. I'd go for the first option.

这篇关于设置两个sql server代理作业之间的依赖关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！