Get started with Jira Service Management for admins
Your first stop for learning how to get started with Jira Service Management.
Integrate with Redgate SQL Monitor
This article highlights a new alerting feature that's natively available in Jira Service Management which is gradually rolling out to some Jira Service Management Cloud customers. It may not yet be visible or available on your site.
What does the integration offer?
Jira Service Management has a specific email integration with SQL Monitor. SQL Monitor sends alerts to Jira Service Management with detailed information. Jira Service Management 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.
How does the integration work?
When an alert is created in SQL Monitor, an alert is also created in Jira Service Management automatically through the integration.
When an alert is closed in SQL Monitor, the related alert is also closed in Jira Service Management automatically through the integration.
Set up the integration
SQL Monitor is an email integration. Setting it up involves the following steps:
Add a SQL Monitor integration in Jira Service Management
Configure the integration in SQL Monitor
Add a SQL Monitor integration
Bidirectional integrations aren’t supported in Free and Standard plans. All the other integrations are supported at a team level in Free and Standard; however, for their outgoing part to work, you need to upgrade to a higher plan. To add any integration at a site level through Settings (gear icon) > Products (under JIRA SETTINGS) > OPERATIONS, you need to be either on Premium or Enterprise.
Adding an integration from your team’s operations page makes your team the owner of the integration. This means Jira Service Management only assigns the alerts received through this integration to your team.
To add a SQL Monitor integration in Jira Service Management, complete the following steps:
Go to your team’s operations page.
On the left navigation panel, select Integrations and then Add integration.
Run a search and select “SQL Monitor”.
On the next screen, enter a name for the integration.
Optional: Select a team in Assignee team if you want a specific team to receive alerts from the integration.
Select Continue.
The integration is saved at this point.Expand the Steps to configure the integration section and copy the email address.
You will use this key while configuring the integration in SQL Monitor later.Select Turn on integration.
The rules you create for the integration will work only if you turn on the integration.
Configure the integration in SQL Monitor
To configure the integration of SQL Monitor with Jira Service Management, complete the following steps:
In Redgate SQL Monitor, select Configuration > Email settings.
Paste the email address copied previously into Send emails to.
Save the changes.
Was this helpful?
Still need help?
The Atlassian Community is here for you.