Help

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.
Hi,
I will go with B option. In this option you could alert an email incase of
failure.
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:O8JNpQ5eEHA.2896@.TK2MSFTNGP11.phx.gbl...
> 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.
>
>
|||What about Option D , Net Send Command ?
Thanks
NOOR
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#xvVx5WfEHA.708@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi,
> I will go with B option. In this option you could alert an email incase of
> failure.
> Thanks
> Hari
> MCDBA
>
> "Noor" <noor@.ngsol.com> wrote in message
> news:O8JNpQ5eEHA.2896@.TK2MSFTNGP11.phx.gbl...
You[vbcol=seagreen]
> DTS
> DTS
> fails.
SQL[vbcol=seagreen]
the[vbcol=seagreen]
> to
process
>