Create a threshold for how many times a job can fail before raising an alert.
We have jobs that fire every minute, or every 5 minutes - similar to heartbeat jobs. If the job fails once or twice, we don't care. If it fails 10 times in a row we do care.
18
votes
![](https://secure.gravatar.com/avatar/297a7b6cf3c73041fbf2d39ce879c34b?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
iliyan Rashev commented
It would be great if we have that option enabled.
For example you have a regularly executed job(every 15 minutes or every hour) which sometimes fails 2-3 times a day for deadlock issue that is out of your control - it will be of great help if we can put such option for job alerts to prevent multiple alerts generated on each failure. -
SQL Data commented
Yes! This would be a fantastic add.