Your company has a Microsoft Azure SQL database named OBI. You create an alert in DB1. You need to ensure that an Azure PowerShell script named alerts.psl runs when the alert is triggered. What…

Adding the script to Azure Blob storage merely stores the script file and does not provide any mechanism to execute it in response to an Azure SQL database alert.

Adding the script to an Azure virtual machine (VM2) would require configuring the VM to monitor the alert and execute the script, which is a less integrated and more complex solution than using Azure Automation runbooks.

To run an Azure PowerShell script in response to an Azure SQL database alert, the script should be added to an Azure Automation runbook. The alert's action group can then be configured to invoke a webhook, which serves as an HTTP endpoint to start the runbook automatically when the alert is triggered.

While the script would be in a runbook, an Azure alert does not directly create an "Azure automation job to start the runbook"; instead, the alert's action group typically triggers the runbook via a webhook, which then initiates an automation job for that specific runbook execution.