You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?

The correct answer is C. Run the sp_configure command. You would need to enable Database email extended procedure using Database Mail XPs configuration option: EXEC sp_configure 'show advanced options', 1; EXEC sp_configure 'Database Mail XPs', 1; Now you can test the configuration by sending emails using sp_send and…

Submitted by ngozi_ng· Mar 6, 2026Configure and manage automation of tasks

Question

You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?

Options

AUse the Agent XPs option.
BEnable the SQL Server Agent.
CRun the sp_configure command.
DRun the sp_set_agent_properties command.

How the community answered

(33 responses)

A
3% (1)
B
9% (3)
C
85% (28)
D
3% (1)

Explanation

You would need to enable Database email extended procedure using Database Mail XPs configuration option: EXEC sp_configure 'show advanced options', 1; EXEC sp_configure 'Database Mail XPs', 1; Now you can test the configuration by sending emails using sp_send and sp_notify_operator https://techcommunity.microsoft.com/t5/azure-sql-blog/sending-emails-in-azure-sql-managed- instance/ba-p/386235

Topics

#SQL Agent jobs#email notifications#sp_configure#SQL Managed Instance

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice