You configure the Microsoft SQL Server Agent service to start automatically. You create a SQL Server Agent operator. You receive email notifications from other SQL Server Agent alerts that have been defined.
You have a SQL Server Agent that is set to notify you through email when error number 50010 occurs. You do not receive any email notifications related to this alert. You verify that the error occurred recently.
You need to determine why this alert is not sending you email notifications.
Why is the alert not sending email notifications?
A . The fail-safe operator is disabled.
B . The alert is enabled.
C . The event is not written to the Windows Application log.
D . The operator is disabled.
Answer: D
Explanation: References: https://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operatornotifications/