Press "Enter" to skip to content

Tracking SQL Agent Job Operations via Extended Events

Lori Brown needs information:

On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete.  I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang. 

Read on to see how Lori was able to collect the info necessary to resolve this issue.