Advance notifications for planned maintenance events (Preview)

Applies to: Azure SQL Database Azure SQL Managed Instance

Advance notifications (Preview) are available for databases configured to use a non-default maintenance window and managed instances with any configuration (including the default one). Advance notifications enable customers to configure notifications to be sent up to 24 hours in advance of any planned event.

Notifications can be configured so you can get texts, emails, Azure push notifications, and voicemails when planned maintenance is due to begin in the next 24 hours. Additional notifications are sent when maintenance begins and when maintenance ends.

Important

For Azure SQL Database, advance notifications cannot be configured for the System default maintenance window option. Choose a maintenance window other than the System default to configure and enable Advance notifications.

Note

While maintenance windows are generally available, advance notifications for maintenance windows are in public preview for Azure SQL Database and Azure SQL Managed Instance.

Configure an advance notification

Advance notifications are available for Azure SQL databases that have their maintenance window configured.

Complete the following steps to enable a notification.

  1. Go to the Planned maintenance page, select Health alerts, then Add service health alert.

    create a new health alert menu option

  2. In the Actions section, select Add action groups.

    add an action group menu option

  3. Complete the Create action group form, then select Next: Notifications.

    create action group form

  4. On the Notifications tab, select the Notification type. The Email/SMS message/Push/Voice option offers the most flexibility and is the recommended option. Select the pen to configure the notification.

    configure notifications

    1. Complete the Add or edit notification form that opens and select OK:

    2. Actions and Tags are optional. Here you can configure additional actions to be triggered or use tags to categorize and organize your Azure resources.

    3. Check the details on the Review + create tab and select Create.

  5. After selecting create, the alert rule configuration screen opens and the action group will be selected. Give a name to your new alert rule, then choose the resource group for it, and select Create alert rule.

  6. Click the Health alerts menu item again, and the list of alerts now contains your new alert.

You're all set. Next time there's a planned Azure SQL maintenance event, you'll receive an advance notification.

Receiving notifications

The following table shows the general-information notifications you may receive:

Status Description
Planned Received 24 hours prior to the maintenance event. Maintenance is planned on DATE between 5pm - 8am1 (local time) in region xyz.
InProgress Maintenance for database(s) in region xyz is starting.
Complete Maintenance of database(s) in region xyz is complete.

1 Start and end time depend on the selected maintenance window.

The following table shows additional notifications that may be sent while maintenance is ongoing:

Status Description
Rescheduled 1) Maintenance is in progress but didn't complete inside maintenance window. 2) there was a problem during maintenance and it could not start. 3) Planned maintenance has started but couldn't progress to the end and will continue in next maintenance window.
Canceled Maintenance for database(s) in region xyz is canceled and will be rescheduled for later.

Permissions

While Advance Notifications can be sent to any email address, Azure subscription RBAC (role-based access control) policy determines who can access the links in the email. Querying resource graph is covered by Azure RBAC access management. To enable read access, each recipient should have resource group level read access. For more information, see Steps to assign an Azure role.

Retrieve the list of impacted resources

Azure Resource Graph is an Azure service designed to extend Azure Resource Management. The Azure Resource Graph Explorer provides efficient and performant resource exploration with the ability to query at scale across a given set of subscriptions so that you can effectively govern your environment.

You can use the Azure Resource Graph Explorer to query for maintenance events. For an introduction on how to run these queries, see Quickstart: Run your first Resource Graph query using Azure Resource Graph Explorer.

When the advanced notification for planned maintenance is received, you will get a link that opens Azure Resource Graph and executes the query for the exact event, similar to the following. Note that the notificationId value is unique per maintenance event.

resources
| project resource = tolower(id)
| join kind=inner (
    maintenanceresources
    | where type == "microsoft.maintenance/updates"
    | extend p = parse_json(properties)
    | mvexpand d = p.value
    | where d has 'notificationId' and d.notificationId == 'LNPN-R9Z'
    | project resource = tolower(name), status = d.status, resourceGroup, location, startTimeUtc = d.startTimeUtc, endTimeUtc = d.endTimeUtc, impactType = d.impactType
) on resource
| project resource, status, resourceGroup, location, startTimeUtc, endTimeUtc, impactType

In Azure Resource Graph (ARG) explorer you might find values for the status of deployment that are bit different than the ones displayed in the notification content.

Status Description
Pending 1) Maintenance is planned on upcoming date. 2) Previously planned maintenance was rescheduled and is waiting to start in the next window. 3) Maintenance started but didn't complete in previous window and will continue in the next one.
InProgress Maintenance for resource xyz is starting or is in progress.
Completed Maintenance for resource xyz is complete.
NoUpdatesPending Previously planned maintenance for resource xyz is canceled and will be rescheduled for later.
RetryLater Planned maintenance for resource xyz has started but couldn't progress to the end and will continue in next maintenance window.

For the full reference of the sample queries and how to use them across tools like PowerShell or Azure CLI, visit Azure Resource Graph sample queries for Azure Service Health.

Next steps