DP-300 Certification Practice Question #184

Question

You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures.

You need to ensure that SQL Server Agent jobs running on SQL1 can notify administrators when a failure occurs.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Accepted Answer

To allow SQL Server Agent jobs running on an Azure SQL Managed Instance to notify administrators when job failures occur, you must configure Database Mail. The SQL Server Agent on a Managed Instance specifically requires a Database Mail profile named exactly `AzureManagedInstance_dbmail_profile`. Therefore, the first step is to create the Database Mail account (which defines SMTP connection settings). Second, you create the Database Mail profile named `AzureManagedInstance_dbmail_profile` and map the account to it. Finally, you configure the individual SQL Server Agent jobs to enable email notifications to be sent to the administrator operator upon failure. Pager notifications are not standard or supported in this context.

More DP-300 practice questions