首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform database maintenance tas
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform database maintenance tas
admin
2009-05-19
33
问题
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.
You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.
What should you do?
选项
A、Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.
B、Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.
C、Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.
D、Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.
答案
B
解析
Explanation: When jobs are completed (successfully or not), the subsystem returns a result status (with optional messages) to SQL Server Agent. SQL Server Agent then records the completion status in both the operating system’s application log and the job history table in SQL Server and optionally sends an e-mail report or an SQL Server event alert of the job status to the designated operator.
Incorrect Answers:
A: We are interested to when the package has completed. The completion status, not the log package execution, should be used to trap the completion of a package. The execution status concerns Last run time, Last run status, Last run message, etc.
C, D: The Messaging Application Programming Interface (MAPI) isn’t installed. MAPI is needed for SQL Server to send e-mail. No e-mail can be send by SQL Server in this scenario.
转载请注明原文地址:https://kaotiyun.com/show/HuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Thepicturedepictsafunnysceneinthehospitalvividly.Severalpeoplearewaitinginquitealongqueueoutsidetheclinicw
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
Guest账户和Administrator账户一样是由系统建立的,不能被禁用。
随机试题
给定资料: 1.世界经济的迅猛发展带来了诸如资源短缺、环境污染、臭氧层被破坏、全球气候变暖、生态失衡等一系列世界性的环境恶化问题。同时,随之而来的环境污染对食物的危害,使人们认识到环境污染、自然生态系统失衡,最终将危及人类自身的生存和发展。许多国际环境公
因社会总支出和产出下降引起的失业称为()
对排列图的观察与分析,通常把累计百分数在80%~90%之间划为B类因素,B类因素是指( )。
某单层仓库内储存有大量同一规格玻璃工艺制品,该工艺品均选用木箱包装,包装后的成品每箱重量为30kg,其中木箱的重量为6.5kg。该仓库的火灾危险}生类别应确定为()。
按计划成本分配法的特点是()。
简述知识概括的类型。
关于创造力与智力的关系,下列哪种表述是正确的()(烟台龙口)
自由:放纵
选择合适的相关系数必须考虑()
A、Theofficeistoonoisytoworkin.B、Toomanystudentsaskquestionsintheoffice.C、Theycan’tpreparetheircoursesadequa
最新回复
(
0
)