首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
94
问题
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
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Evenbeforetheopeningceremony,arecordhadbeenbrokenatSochi:12newevents,themostforanyOlympics,werescheduledto
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
小组教学法中出现个别好说的活跃学员时,教师最好的解决方案是【】
服用药后需要多饮水的机制A、平喘药(茶碱类)B、利胆药(去氢胆酸)C、抗痛风药(别嘌醇)D、氨基糖苷类抗生素E、双膦酸盐(阿伦膦酸钠)防止尿酸沉积形成结石
静脉输液时,茂菲滴管内的液面自行下降,原因是
泥浆护壁成孔灌注桩施工,孔壁土质较差时,清孔后的泥浆相对密度应控制在( )。
根据行政法理论,下列属于行政给付的形式有()。
下列各项中,工业企业应计入其他业务成本的有()。
结合教学实际,谈谈目前中学化学实验教学的现状和改革的思路。
张贴年画是中国的传统年俗,是一年只用一次、标识化、符号化“年”的代表。鼠年春节期间,面对新型冠状病毒感染的肺炎疫情,一些地方________,给年画中的人物“戴上口罩”,用年画作为疫情宣传的________,将疫情防控知识介绍与传统年俗活动巧妙地结合在一起
"AMZN"isafour-letterwordtomanybooksellers.Theonlineretailerhasbeen【C1】______ofkillingthebooksellingindustry.It
TeainBritainTea,thatmostessentialEnglishdrinks,isarelativelatecomertoBritishshores.Althoughthecustomofd
最新回复
(
0
)