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.