Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted
Updated 19-Mar-18 22:55pm

1 solution

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.
 
Share this answer
 
Comments
Jamie888 20-Mar-18 21:34pm    
Yes sir, i believe this is the case. I have setup 3 different jobs pointing to the same package with same scheduled time and let it run. Just the requirement limitation that is preventing me from run the job in a sequential basis.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900