首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
admin
2009-05-19
74
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Writealettertoamuseum’sstafftoaskforsomeinformationaboutahistoricalexhibition.Youshouldincludethedetailsyou
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
Emilyislisteningtonetworktrafficandcapturingpasswordsastheyaresenttotheauthenticationserver.Sheplanstouseth
随机试题
过滤气泡是指以大数据与算法推荐为底层架构,根据用户的使用时间、地区以及浏览习惯生成用户画像,并通过算法技术为其呈现独一无二的界面体验。网络上这种针对个人化搜索而提供筛选后结果的推荐算法,被称为过滤气泡。根据上述定义,下列不属于过滤气泡的是:
患者45岁,女性,因近2个月来右上后牙遇冷水及吃酸甜食痛,咬硬物酸软无力,无自发痛史。检查时可见:釉质磨损,浅黄色牙本质外露,硬而光滑,探针探划时每牙面有一点酸痛难忍。该处理方法可用到的药物或材料是
克雷伯杆菌肺炎的典型临床表现是
采用旋转薄膜烘箱加热试验评价沥青的抗老化能力的指标有()。
甲公司以公允价值对投资性房地产进行后续计量。甲公司20×7年度与投资性房地产有关的交易或事项如下: (1)出租厂房20×7年末的公允价值为1650万元,该厂房上年末的账面价值为1700万元; (2)20×7年1月1日,将原拟自用的商品房改为出
关于校准,下列说法不正确的是()。
孔子对我国教育的贡献有_______、_______和_______三个方面。
A、 B、 C、 D、 A从每列来看,前两个图形叠加,斜线+斜线=斜线、竖线+黑色=空白、空白+空白=竖线,由此得到第三个图形。按照这种叠加规律,应选择A。以上两个经典真题主要考查叠加,考生应学会通过横向或
下列选项中,不属于西周婚姻制度中婚姻缔结原则的是()。
追星族
最新回复
(
0
)