Job failing Alert option for number of consecutive failures in a row
I have some SQL Agent jobs that run every 2 minutes and legitimately fail occasionally to circumstances outside our control.
I need to be alerted if the job is constantly failing, e.g. failed 5 times in a row, but I do not care about one off failures.
Having a customisable option for individual jobs to alert only after X consecutive failures would be fantastic.
3
votes
Daniel Merchant
shared this idea