Alerts Only When Job Fails Multiple Times

SteveLowe

Is there a way to have SQL Monitor ONLY alert when a job fails x times in a row. We have jobs that regularly fail for reasons outside of our control and would only be concerned if there were a number of consecutive failures?

Alex B

Hi @SteveLowe,

Unfortunately there is not a way to do this; the alert will fire when the job fails the first time.

I've found this Uservoice suggestion that seems to match what you are looking for, so please vote on it and add any comments you may have to clarify if needed https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/44520282-create-a-threshold-for-how-many-times-a-job-can-fa

Kind regards,
Alex