• Products
  • Get started
  • Documentation
  • Resources

Integrate Opsgenie with RedGate SQL Monitor

RedGate logo

What does Opsgenie offer SQL Monitor users?

Opsgenie has a specific email integration with SQL Monitor. SQL Monitor sends alerts to Opsgenie with detailed information. Opsgenie acts as a dispatcher for SQL Monitor alerts, determines the right people to notify based on on-call schedules– notifies via email, text messages (SMS), phone calls and iPhone & Android push notifications, and escalates alerts until the alert is acknowledged or closed.

Functionality of the integration

  • When an alert is created in SQL Monitor, an alert is also created in Opsgenie automatically through the integration.

  • When an alert is closed in SQL Monitor, the related alert is also closed in Opsgenie automatically through the integration.

Add Red Gate SQL Monitor integration in Opsgenie Expand

  1. Log in to your Opsgenie and go to Settings. Select Integration list and search for Red Gate SQL Monitor. Hover over the item and select Add.

Under the Free and Essentials plans, the tabs under the Team dashboard are limited to Main, Integrations, Members, and Activity Stream.

2. Specify who is notified of SQL Monitor alerts using the Teams field. Auto-complete suggestions are provided as you type.

An alternative for Step 1) and Step 2) is to add the integration from the Team Dashboard of the team which will own the integration. To add an integration directly to a team, navigate to the Team Dashboard and open Integrations tab. Click Add Integration and select the integration that you would like to add.

3. Copy the integration email address to use in SQL Monitor configuration.

4. Click Save Integration.

Configuration on RedGate SQL Monitor

  1. In RedGate SQL Monitor, click the Configuration tab.

  2. Under "Alerts and metrics", select Email settings.

  3. Paste the Integration email to the Send Emails to box.

Last modified on Feb 3, 2021
Cached at 12:01 AM on Apr 13, 2021 |

Additional Help

Ask the Community