DP-300 · Question #293
Drag and Drop 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…
The correct answer is Create a Database Mail account.; Create a profile named AzureManagedInstance_dbmail_profile.; Enable email notifications upon failure. To enable SQL Server Agent job failure notifications on Azure SQL Managed Instance, you must first create a Database Mail account to define the SMTP server and sender credentials. Next, you must create a profile named specifically 'AzureManagedInstance_dbmail_profile' - this is…
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- Create a Database Mail account.
- Create a profile named AzureManagedInstance_dbmail_profile.
- Enable email notifications upon failure.
Explanation
To enable SQL Server Agent job failure notifications on Azure SQL Managed Instance, you must first create a Database Mail account to define the SMTP server and sender credentials. Next, you must create a profile named specifically 'AzureManagedInstance_dbmail_profile' - this is the reserved, hardcoded profile name that Azure SQL Managed Instance requires for SQL Server Agent to send email notifications; no other profile name will work. Finally, you enable email notifications upon failure in the SQL Server Agent job step or operator configuration to trigger alerts when jobs fail.
Topics
Community Discussion
No community discussion yet for this question.