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:Whenjobsarecompleted(successfullyornot),thesubsystemreturnsaresultstatus(withoptionalmessages)toSQLServerAgent.SQLServerAgentthenrecordsthecompletionstatusinboththeoperatingsystem'sapplicationlogandthejobhistorytableinSQLServerandoptionallysendsane-mailreportoranSQLServereventalertofthejobstatustothedesignatedoperator.IncorrectAnswers:A:Weareinterestedtowhenthepackagehascompleted.Thecompletionstatus,notthelogpackageexecution,shouldbeusedtotrapthecompletionofapackage.TheexecutionstatusconcernsLastruntime,Lastrunstatus,Lastrunmessage,etc.C,D:TheMessagingApplicationProgrammingInterface(MAPI)isn'tinstalled.MAPIisneededforSQLServertosende-mail.Noe-mailcanbesendbySQLServerinthisscenario.