Backup status alert for Azure Database for MySQL - Single Server

Question

Microsoft documentation:
Azure Database for MySQL - Single Server takes backups of the data files and the transaction log.These backup files are not user-exposed and cannot be exported. These backups can only be used for restore operations in Azure Database for MySQL.

I want to create alert rules for those backups if anythings goes wrong. the only metrics i see in the logs is the used backup storage

AzureMetrics 
| where MetricName == "backup_storage_used" 

Is there any solution to create the alert rules with the backup status?

Answer 1

I get the backup failed alerts by using below process:

Firstly go to create an alert and then click on select scope then click on subscription, resource type and the resource group like below:

Then select signal then click on Activity log in signal type, Then select Export an existing database,

Then select Failed in status as below and then next :

Then select or create a action group:

Then next and fill details and then create like below:

This is the process I follow and I get alerts when the back up fails.