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