Can One job trigger another 1

[mjp483]

I want to set up a job, that runs at night, when it finishes I want another job on another server to begin, and when this is complete I want a DTS package to start....

Can I do this all through DTS or Jobs?

Any suggestions?

 

[mkal]

When creating a new job you have the option to have create multiple steps. Each step to perform one of the tasks needed. On the advance tab you have the choice of "On Success" of the step: to "Goto the next step" or "Quit the job reporting success" or "Quit the job reporting failure". So you should be able to create a 3 step job to perform whats needed.

Or create a single DTS package to perform all three steps and schedule it run when needed. You could also create 3 separate DTS packages for each step, then create a fourth package that calls and runs the three of them at a specified time.

Lots of options, hope this helps.

 

[mjp483]

Thanks this is very helpful. Mike