首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
58
问题
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]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
敲钟人卡西莫多的形象出自文学大师雨果创作的()。
根据域名代码规定,域名为.edu表示的网站类别应是______________。
()是保障人员生命安全的最基本的建筑消防系统。
根据K线理论,K线实体和影线的长短不同所反映的分析意义不同,譬如( )。
甲、乙因合同纠纷达成仲裁协议,甲选定A仲裁员,乙选定B仲裁员,另由仲裁委员会主任指定一名首席仲裁员,3人组成仲裁庭。仲裁庭在作出裁决时产生了两种不同意见。根据《仲裁法》的规定,仲裁庭应当采取的做法是()。
美育就是对学生进行()。
胡锦涛在十八大报告中指出,要全面落实经济建设、政治建设、文化建设、社会建设、()五位一体总体布局。
焦急:焦躁:着急
未婚:无权
设矩阵A=仅有两个不同的特征值,若A相似于对角矩阵,求a,b的值,并求可逆矩阵P,使P﹣1AP为对角矩阵.
最新回复
(
0
)