2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during t

You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during t

admin2009-05-19  36
问题 You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.
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
答案A
解析 Explanation: SQLAgentMail must be used when mail stored procedures are used to send notifications to operators by e-mail or pager. In order to use SQLAgentMail, a mail profile must be configured for SQL Server Agent to use to connect to the mail server and the mail server must be extended MAPI-compliant.

Incorrect Answers:
B: SQL Mail provides a way to receive e-mail messages generated by SQL Server 2000. Messages can be triggered to provide information about the status of a job or a warning caused by an alert. SQL Mail can include a result set in a reply to e-mail messages that contain queries and allows SQL Server to send and receive e-mail by establishing a client connection with a mail server. However, SQL Mail must have a mail profile created in the same user domain account or context that is used to start an instance of SQL Server 2000 as it looks for the defined mail profile in the domain account that triggered the e-mal message.

C: Net send is used to sends messages to other users, computers, or messaging names across a network. The Messenger service must be running to receive messages. It is not used for e-mail or paging purposes.

D: The xp_startmail stored procedure is used to start a SQL Mail client session. If there is an existing mail session, xp_startmail does not start a new one. If mail is being used on the same computer on which SQL Server is also running, the mail client must be started either before xp_startmail is executed, or before SQL Server is started if SQL Mail is configured to automatically start when SQL Server starts.
转载请注明原文地址:https://kaotiyun.com/show/CuhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)