0

I have the following doubt, is there a possibility to have faild a Job when are running simultaneously as the following example:

4 SQL Agent Jobs running the same SSIS in different schedules, I've heard that the max number of possible execution is 4, but not sure if that is a parameter that can be changed or not, if so, have you heard about it ?

3

You may be referring to the MaxConcurrentExecutables property. It controls how many parallel threads may run during the execution of the package and it can be changed on the package properties.

MaxConcurrentExecutables

The default is -1 which translates to 'how many cores ya got'+2. I haven't ever heard of anything that would stop either the SQL Agent or the Integration Server to limit the number of concurrent executions of a single package.

Check out this article on MaxConcurrentExecutables.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.