Job Duration Unusual alert does not fire until job complete?

MckMurray · November 28, 2016 9:48AM

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 · November 29, 2016 10:28AM

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 · July 5, 2017 3:36PM

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

rre · November 8, 2018 3:19PM

Do you have any update for this topic?

Russell D · May 10, 2019 7:33AM

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.

Job Duration Unusual alert does not fire until job complete?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk