You are the administrator of a SQL Server 2000 computer. You create several jobs on the se
You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.
You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?
A.Configure SQLAgentMail to use a valid MAPI profile
B.Configure SQL Mail to use a mailbox that delegates permissions to the operator
C.Use the net send notification method to send the operator e-mail messages
D.Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts