Job calling SSIS Packages are getting hung, When I restart the job, job shows running in but I can see below error in SQL agent Error log.

Restarting SQL agent solves the issue. This happened multiple times

Errr: Unable to terminate process 6444 launched by step 2 of job 0x8D97112510AC1149A5B709A748313A47 (reason: Access is denied)

Your Answer

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

Browse other questions tagged or ask your own question.