Home > IT Answers > SQL Server > How to Schedule jobs in DTS in sql server 20...

Question

Asked: May 7 2008 5:14 AM GMT
Asked by: SRI HARSHA

How to Schedule jobs in DTS in sql server 2000

I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

Subscribe to Alerts! Get questions and answers delivered to your Inbox.

Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER

View History

RATE THIS ANSWER

0
Click to Vote:

Last Answered: May 7 2008 6:42 PM GMT by Mrdenny

DTS is not the correct solution for doing this.

You can either put all the jobs together by taking all the job steps from all 7 jobs and placing them into a single job, or you can have each job run the next job in the sequence by using the sp_start_job command.