What should you include in the solution?

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1.

You need to ensure that an automatic email notification is sent once the job completes.

What should you include in the solution?
A . From SQL Server Configuration Manager (SSMS), enable SQL Server Agent
B. From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties
C. From SQL Server Management Studio (SSMS), create a Database Mail profile
D. From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action

View Answer

Answer: C

Explanation:

To send a notification in response to an alert, you must first configure SQL Server Agent to send mail.

Using SQL Server Management Studio; to configure SQL Server Agent to use Database Mail:

✑ In Object Explorer, expand a SQL Server instance.

✑ Right-click SQL Server Agent, and then click Properties.

✑ Click Alert System.

✑ Select Enable Mail Profile.

✑ In the Mail system list, select Database Mail.

✑ In the Mail profile list, select a mail profile for Database Mail.

✑ Restart SQL Server Agent.

Note: Prerequisites include:

✑ Enable Database Mail.

✑ Create a Database Mail account for the SQL Server Agent service account to use.

✑ Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole in the msdb database.

✑ Set the profile as the default profile for the msdb database.

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail-to-use-database-mail