Job Duration Unusual alert does not fire until job complete?

MckMurray

I discovered the hard way today that the Job Duration Unusual alert seems to only fire once the long-running job has completed or been manually stopped. Really??

This is an issue, and defeats a major purpose of the alert, namely that if a job hangs for any reason, I need to know about that and intervene.

Can this be fixed?

Dan B

Hi MckMurray,

Thanks for posting on the Redgate forums.

There is an open bug request for this with internal reference SRP-10912. I will update this forum post further when I get any news on this.

awalther_golf

Would really love to see this fixed. Catching a "hung" job is our principal objective with this alert as well.

rre

Do you have any update for this topic?

Russell D

I came across this thread in a search, so it's a little overdue but no this hasn't been implemented yet. Just to clarify this isn't a bug, but an enhancement request: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/33919051-job-duration-taking-too-long-triggering-while-jo.