Skip to main content
Use the webhook notifications of Redgate Monitor (formerly Redgate SQL Monitor) to send alerts for SQL Server, Azure SQL, and other monitored databases to Flashduty On-call. Each Redgate Monitor alert maps to one Flashduty alert: it triggers when the alert is raised (Raised), updates when its severity goes up (Escalated) or down (DeEscalated), and recovers automatically when the alert ends (Ended).

In Flashduty On-call

You can get the integration push URL in either of the following ways.

Use a dedicated integration

  1. In the Flashduty console, select Channel and open a channel
  2. Select Configuration → Integrations → Private integration, then click Add integration
  3. Select Redgate SQL Monitor, then click Save
  4. Open the generated integration card and copy the Push URL

Use a shared integration

  1. In the Flashduty console, go to Integration Center → Alert Events
  2. Select Redgate SQL Monitor and enter an integration name
  3. Configure the default route and select a channel. You can add more rules under Routing after creation
  4. Click Save and copy the generated Push URL

Configure Redgate Monitor

Webhook notifications are configured in the Redgate Monitor web console, apply to every alert raised by that Base Monitor, and require administrator permissions. The machine that runs the Base Monitor service must be able to reach the Flashduty push URL.
1

Configure webhook notifications in Redgate Monitor

Where: Redgate Monitor web console › Configuration › Alerts › Notification settings › Webhook notificationsSave the settings.
2

Send a test and confirm an alert

Where: Redgate Monitor web console › Configuration › Alerts › Notification settings › Webhook notifications › Send Test Notification
  1. Click Send Test Notification to confirm that Redgate Monitor can send messages to Flashduty. This is only a connectivity check. Redgate does not document the content of the test message; if it creates an alert in Flashduty, close that alert manually
  2. Wait for a real alert to be raised and confirm that Flashduty receives an active alert. After the alert ends in Redgate Monitor, confirm that the Flashduty alert recovers
After a few seconds, go back to Flashduty. If the integration shows a Latest event time, the setup works.
If the Base Monitor reaches the internet through a proxy, configure the proxy on the Base Monitor machine as described in the Proxy configuration section of Setting up Webhook notifications.

Alert key

A Redgate Monitor alert ID (id) is unique only within a single Base Monitor, so Flashduty computes the Alert Key from both the Base Monitor identifier (baseMonitorGuid) and the alert ID (id). The Raised, Escalated, DeEscalated, and Ended messages of one alert share the same Alert Key, and alerts from several Base Monitors that push to the same integration never merge. Changes to the alert name, severity, description, or timestamps do not change the Alert Key. Messages without id or baseMonitorGuid are rejected.

Status and severity

An Ended message carries severity None, so Flashduty uses previousSeverity (the severity before the alert ended) as the severity of the recovery event. An empty or unrecognized severity is treated as Warning. Messages whose messageType is not AlertNotification do not create alerts; Flashduty returns success for them.

Labels

The alert description is Redgate Monitor’s description of the alert type. For a custom metric with a secondary query, it also includes the detail text that query returns (alertDetailText).

Troubleshooting

  • The test message fails: Confirm that the Base Monitor machine can reach the Flashduty push URL, and configure the proxy as described above if one is required
  • Flashduty returns a parameter error: Confirm that the URL is complete and includes integration_key, and that the default message format is selected
  • An alert does not recover: Redgate Monitor sends a webhook 20 seconds after it receives an alert and retries once after 10 minutes if delivery fails. If both attempts fail, the message is lost and you need to close the alert in Flashduty manually. Each alert type also has a limit on how many notifications it can send for each monitored object in 24 hours (30 by default); raise it if alerts change often
  • Alerts arrive with a delay: Webhook messages are sent about 20 seconds after the alert is raised, which is expected
For field details, see Redgate Monitor webhook notifications.