首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
30
问题
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
Evenbeforetheopeningceremony,arecordhadbeenbrokenatSochi:12newevents,themostforanyOlympics,werescheduledto
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
高速钢梯形螺纹车刀的背前角应为()。
对于一个有写保护装置的U盘,当它处于写保护状态时,以下操作可以实现的有________________。
甲公司向乙厂购买一批瓷砖,双方在买卖合同中没有约定瓷砖的质量标准和等级,也未封存样品。乙如期发货甲验货后支付了货款。过了一段时间,甲剩余一些没有销出,便以产品质量不合格为由起诉乙,并主张合同无效。下列表述正确的是()。
下列关于商品品质的约定方法,不属于实物表示法的有()。
一般的,我们可以把个人拥有的资源定义为营生资产,把个人对家庭的责任定义为养生负债。营生资产是指()
量化投资即借助数学、物理学、几何学、心理学甚至仿生学的知识,通过建立模型,进行()。Ⅰ.分析Ⅱ.估值Ⅲ.择时Ⅳ.选股
根据营业税改征增值税的有关规定,下列各项中,属于增值电信服务的有()。
文艺复兴运动发源于意大利的根本原因是()
公众人物需要担当更多的道德责任,因为权力和责任是相等的,既然拥有常人不具备的优势地位,那么就应该比一般人承担更高的道德要求。因此,承受更多的舆论批评甚至人身攻击,哪怕是一定程度的失真,也是不得不付出的必要代价。最能质疑上述观点的一项是
Therewerealotofpeoplestandingatthedoorandthesmallgirlcouldn’tget______.
最新回复
(
0
)