Advance notifications for planned maintenance events (Preview)

APPLIES TO: Azure SQL Database

Advance notifications (Preview) is available for databases configured to use a non-default Maintenance Window (Preview). 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.

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 the ability to choose a maintenance window is available for Azure SQL managed instances, advance notifications are not currently available for Azure SQL managed instances.

Create 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 Deployment Received 24 hours prior to the maintenance event. Maintenance is planned on DATE between 5pm - 8am (local time) for DB xyz.
In-Progress Maintenance for database xyz is starting.
Complete Maintenance of database xyz is complete.

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

Status Description
Extended Maintenance is in progress but didn't complete for database xyz. Maintenance will continue at the next maintenance window.
Canceled Maintenance for database xyz is canceled and will be rescheduled later.
Blocked There was a problem during maintenance for database xyz. We'll notify you when we resume.
Resumed The problem has been resolved and maintenance will continue at the next maintenance window.

Next steps