使用相同包的不同代理作业 [英] Different agent jobs using the same package

问题描述

我有三（3）个SQL代理作业，我使用SSIS 2016架构在我的服务器中设置了它。所有作业都使用具有相同预定运行时间的相同包，例如下午12点日常。对于单个包，我有三（3）个不同的环境和每个相应的环境变量。

每个作业将指向不同的环境但是相同的包。我很困惑的是，当工作正在执行时，他们每个人都有自己的图像或镜像包，或者他们会相互冲突，因为所有工作将同时执行。



我尝试了什么：



1.在线查看解释，但没有相同的case as as mine。

Hi, i have three(3) SQL Agent Jobs which i have setup in my server using SSIS 2016 architecture. All the jobs are using the same package with same scheduled run time, e.g. 12 p.m. daily. For the single package, i have three(3) different environments with each respective environment variables.
Each job will point to different environment but the same package. I am confuse on whether when the job is executing, will each of them have their own "image" or "mirror" package or will they conflict with each other as all the jobs will get executed at the same time.

What I have tried:

1. Looked online for explanation but none have the same case as mine.

推荐答案

每个作业都在一个单独的过程中运行，所以我希望一切都好。如果您发现情况并非如此，只需将每个作业安排在上一个作业之后开始。

Each job runs in a separate process, so I would expect everything to be fine. If you find that this is not the case, simply schedule each job to start after the previous job.

这篇关于使用相同包的不同代理作业的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！