• 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

You can add this integration from your team dashboard

If you're using Opsgenie's Free or Essentials plan, or if you’re using Opsgenie with Jira Service Management's Standard plan, you can only add this integration from your team dashboard as the Integrations page under Settings is not available in your plan.

Adding the integration from your team dashboard will make your team the owner of the integration. This means Opsgenie will assign the alerts received through this integration to your team only.

To do that,

  1. Go to your team’s dashboard from Teams,

  2. Select Integrations, and select Add integration.

Follow the rest of the steps to complete the integration.

  1. Go to Settings → Integrations. Search for Red Gate SQL Monitor and select Add

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

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

  4. Select 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.

Additional Help