DP-300 · Question #293
DP-300 Question #293: Real Exam Question with Answer & 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 t
Question
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 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. Answer:
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.