DTS Jobs

[Prasad]

Hi,

How do we add DTS pakages to a scheduled job ?
Ex: Lets say i have 2 DTS pakages One has got to run immediately after the other.
>Now i create a schedule for the main DTS pakage.

>Once i create a schedule, It goes into Jobs as a Scheduled job.

>Now in the propertied part of the first DTS job i need to add a second DTS
as Step2, mentioning that it should run after the First DTS.

How do we do this ?

Thanks in Advance,
Siv

[Martin]

Hi,

to do it, you have to open the properties of your first job and go on the tab "Step". Add a new one of type "Operating System Command" and use the following line of code :
DTSRun /s"Server Name" /u"Username" /p"Passowrd" /n"DTS Package Name"

After this, go back to Edit your first step and go on the "Advanced" tab. There you can change the action for the "On failure" and "On Success" to point on your second step.

Hope this help

Martin


------------
Prasad at 3/5/01 3:24:37 PM

Hi,

How do we add DTS pakages to a scheduled job ?
Ex: Lets say i have 2 DTS pakages One has got to run immediately after the other.
>Now i create a schedule for the main DTS pakage.

>Once i create a schedule, It goes into Jobs as a Scheduled job.

>Now in the propertied part of the first DTS job i need to add a second DTS
as Step2, mentioning that it should run after the First DTS.

How do we do this ?

Thanks in Advance,
Siv