Results 1 to 4 of 4

Thread: DTS schedule

  1. #1
    Join Date
    Nov 2002
    Posts
    6

    Unanswered: DTS schedule

    I have 2 DTS and i want to make sure that DTS2 runs after the DTS1 has finished, how can i do this????

    Thanks,

    Joo Martins

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Can you run dts2 within dts1 or does it have to be run outside of dts1 ?

  3. #3
    Join Date
    Nov 2002
    Posts
    6
    dts2 must run outside dts1

  4. #4
    Join Date
    Oct 2002
    Posts
    29
    When you schedule a DTS package using EM, it creates a job with the name same as the package. This job has only one step - with the name same as the package. However, you can add more steps to the job and specify the sequence in which they will run. The job will be under EM - Server - Management - SQL Server agent - Jobs.
    Regards, Ravi.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •