You have an Azure SQL managed instance. You need to configure the SQL Server Agent service to email job notifications. Which statement should you execute?

The correct answer is C. EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name =. To send e-mail using SQL Agent jobs in SQL Managed Instance, there should be a profile that must be called AzureManagedInstance_dbmail_profile. Otherwise, SQL Managed Instance will be unable to send emails via SQL Agent…

Submitted by klara.se· Mar 6, 2026Configure and manage automation of tasks

Question

You have an Azure SQL managed instance. You need to configure the SQL Server Agent service to email job notifications. Which statement should you execute?

Options

AEXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = 'sysadmin_dbmail_profile';
BEXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = 'application_dbmail_profile';
CEXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name =
DEXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = 'sys_dbmail_profile';

How the community answered

(27 responses)

B
4% (1)
C
93% (25)
D
4% (1)

Explanation

To send e-mail using SQL Agent jobs in SQL Managed Instance, there should be a profile that must be called AzureManagedInstance_dbmail_profile. Otherwise, SQL Managed Instance will be unable to send emails via SQL Agent. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed- instance?view=azuresql#sql-agent-job-notifications

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice