Configurable Alert Thresholds for notification alerts
I would like to suggest a new alerting feature for Redgate Monitor: the ability to configure notification thresholds based on the number of consecutive occurrences of an event.
For example, for SQL Server Agent Job failures, it would be useful to define a threshold so that an alert is triggered only after a job has failed a specified number of consecutive times (e.g., 3 or 5 failures), rather than generating a notification for every individual failure.
This enhancement could help reduce alert fatigue and notification noise, especially in environments where occasional transient failures may occur and do not require immediate attention. By allowing users to focus on recurring or persistent issues, alerting would become more meaningful and actionable.
Ideally, this capability could be available for SQL Agent Job failure alerts and potentially extended to other alert types where repeated occurrences are more significant than isolated events.
Thank you for considering this suggestion.
Matteo Dal Bianco
shared this idea
-
Daniel Merchant commented
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.
-
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.
-
Jack Parker
commented
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.
-
Carla Romere
commented
I would like to be able to customize alerts by job. For instance, I have many jobs that run multiple times per hour. If it fails once or twice, I don't want to be alerted about it. However, if it fails 3+ times in a row, I want to be alerted.