首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
45
问题
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
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
TheBestMediatoUseThereareplentyofoptionsavailableforspreadingnews,suchasnewspapers,radio,TV,theInternet
BarackObamaspentmuchtimeonthecampaigntrailproposingadramaticvisiontochangenotonlytheUnitedStatesforthebett
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
Today,cigarettesmokingisacommonhabit.Aboutforty-threepercentoftheadultmenandthirty-onepercentoftheadultwomen
估值错误的处理包括( )。
按照相关规定,贷款人受托支付是指()。
良好的班集体具有积极的作用,具体表现为()
作为执勤交警.当你处理一起交通事故时发现受害人昏迷不醒,并且无经济能力.请问你该如何处理?
如图所示,OA、OB是竖直平面内两根固定的光滑细杆,O、A、B、C位于同一圆周上,C为圆周的最高点,A为最低点。每根杆上都套着一个小滑环,两个滑环都从O点无初速释放,用t1、t2分别表示滑环到达A、B所用的时间,则下列关系正确的是:
条件语句控制程序的流程是通过判断【】来进行的。
Minipresentation—about5minutesInthispartofthetestyouareaskedtogiveashorttalkonabusinesstopic.Youhavetoc
We’ll______youforanydamagedonetoyourhousewhileweareinit.
NinetypercentofAmericansknowthatmostoftheircompatriotsareoverweight,butjust40percentbelievethemselvestobetoo
最新回复
(
0
)