How do you use cloud databases? Take the survey.

Detecting long running but incomplete SQL jobs

Hello, is there a way to detect and subsequently alert on long running, but incomplete, jobs?

The challenge linked to this is described in the Comment section of the following article.

The dbo.sysjobhistory table is only updated after the job step has completed. This means we cannot be alerted about a job taking longer than expected until the jobstep is finished. 



Sign In or Register to comment.