Skip to content

In Redgate Monitor, I want to...

← Suggestions
'Create a threshold for how many times a job can fail before raising an alert.' has been merged into this idea

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.

30 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Matteo Dal Bianco shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Daniel Merchant commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    Yes! This would be a fantastic add.

  • Jack Parker commented  ·   ·  Report

    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  ·   ·  Report

    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.

Suggestions

Categories