-1

I've seen this bug before and I don't know what made it go away in the past. I have a test server that has three jobs that each kick off their own SSIS package. In production this works fine and there are only ever three ISServerExec processes in Task Manager, but on this one test server the number just goes up and up until it runs out of RAM. When I look at the Integration Services Reports it shows that each job is getting kicked off again before it finishes running. I'm on SQL Server 12.0.5000.0.

Improve this question
1
  • Have you considered upgrading to the latest cumulative update? You may find that this issue was addressed by one of the updates. Worth looking into, at any rate.
    – Randolph West
    Commented Feb 9, 2018 at 17:03

1 Answer 1

Reset to default
0

I found the fix but I can't explain what changed to make the fix necessary. I added the "SYNCHRONIZED" parameter to the package parameters of the Agent job step and then the job acted normally, waiting for the package to finish and marking the job as successful only when it actually was.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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