首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
55
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
TheoutbreakofswinefluthatwasfirstdetectedinMexicowasdeclaredaglobalepidemiconJune11,2009.Itisthefirstwo
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
GivingmillionsofexistingPayPalcustomerstheabilitytobuyattheclickofabuttonhasenormouspotentialforincreasing
随机试题
月经周期为28天的妇女,要取子宫内膜活检测定是否有排卵,最好在周期的第
试论述学校和其他教育机构的义务。
《春江花月夜》一诗中由人生感叹转向写游子思妇的一句诗是()
下列关于气机失常病机的描述,不确定的是
患者,女,30岁,大叶性肺炎,遵医嘱给予补液抗感染治疗。在输液过程中,患者自诉胸闷异常不适,随之出现呼吸困难。查体:口唇发绀,听诊心前区可闻及响亮持续的“水泡声”。应立即采取的措施是
除另有规定外,一般片剂的崩解时限是泡腾片按规定方法检查6片,每片完全崩解的时间是
关于再审裁判,下列说法正确的是:()
影响企业筹资、投资和收益分配的法律法规是()。
某校的学生刚好排成一个方阵,最外层的人数是96人,问这个学校共有学生()。
通过符号的任意性特点,我们可以解释为什么人类社会有各种各样的语言。()
最新回复
(
0
)