SQL Agent Job step does not finish
Hi, I have a SQL Agent Job with 5 steps running several SSIS Packages on MSDB. Today the 3rd of 5 Steps did not finish and the Job was hanging in this state. I checked the sysssislog where I log the onPostExecute events and saw that the PackageEnd Event was logged as always. So it seems like the Job Agent did not notice the end of the step and does wait forever. After I stopped the Job and restarted it beginning with step 4 it went through like it should. I noticed this behaviour in some rare cases some time ago, but it never had a bigger impact. But now I want to identify and solve this problem. Does anyone have an idea what else I could check or ist there anyone that had the same problem?
January 24th, 2012 2:34am

Hi, did you check about the execution of the job, may it waiting for resources that used by another job. check the lock using DMVs and ensure it does not wait for resources. I hope this is helpful. Elmozamil Elamir MyBlogPlease Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem Elmozamil Elamir Hamid http://elmozamil.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
January 24th, 2012 4:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics