首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
107
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Writeanessayof160-200wordsbasedonthefollowingdrawing.Inyouressay,youshould1)describethedrawingbriefly,
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
Supposeyouhavefoundsomethingwrongwiththebookthatyouboughtfromanonlinestoretheotherday.Writeane-mailtothe
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Whateverhappenedtothedeathofnewspaper?Ayearagotheendseemednear.Therecessionthreatenedtoremovetheadvertising
随机试题
下列哪项是豆蔻的主治病证
A、休息,低盐饮食,限制入水量,补蛋白质,给利尿剂B、休息,高热量高蛋白饮食,保肝治疗C、休息,高热量限蛋白饮食,输入支链氨基酸D、休息,禁食,积极补足血容量并采取止血措施E、休息,控制输液量,纠正电解质紊乱,限制蛋白治疗肝硬化合并水钠潴留(
以下关于双侧颞下颌关节急性前脱位的叙述,哪项是错误的
某中外合资经营企业因对市政府决定其与另外一家企业合并不服。对该决定,下列有权以,自己的名义提起行政诉讼的是( )。
实验室所有记录应清晰明了,并以书面文件的方式存放和保存在具有防止损坏、变质、丢失等适宜环境的设施中,应规定记录的保存期。()
【2010年第4题】题21~25:某台10kV笼型感应电动机的工作方式为负荷平稳连续工作制,额定功率800kW,额定转速2975r/min,电动机启动转矩倍数0.72,启动过程中的最大负荷转矩899N.m。请回答以下问题,并列出解答过程。若电动机的额定
表示热轧光圆钢筋的符号为()。
进行套期保值是为了( )。
《局外旁观论》
在Access中,DAO的含义是()。
最新回复
(
0
)