Results 1 to 4 of 4

Thread: Job scheduling

  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: Job scheduling

    Hi,

    I have two jobs scheduled on the Agent. Each job has ten steps. The next step is executed only if the previous suceeds.

    I want Job 2 to execute only if Job 1 suceeds. How do I schedule that?

    I was thinking that I can have the ten steps of Job 2 as steps (11 to 20) of Job 1 with each step executing after the previous one succeeds. If I do that then I can get rid of Job 2.

    Let me know what approach you would advise.

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    thats what i would do

  3. #3
    Join Date
    Jan 2004
    Posts
    35
    I think that is the only option. I am not aware of any other way of controlling the job sequence.

  4. #4
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    You don't have to merge two jobs into one. At the end of job1, on step 10 choose "go to next step if succeeds" and then add one more step with command:

    exec sp_start_job @job_name = job2

Posting Permissions

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