Post reply

How to run 4 jobs in single job in sql server 2008

  • October 11, 2012 at 6:52 am

    #393361

    Hi all,

    Could you please tell me any one.

    My boss said to me run the four jobs in single job. How it is possible please help me some one .

    Thanks in advans

  • October 11, 2012 at 6:55 am

    #1548072

    Hi,

    You can create multiple steps in a single job. so by creating multiple steps you can move your 4 jobs to single job.

  • October 11, 2012 at 6:59 am

    #1548074

    It depends on what you call a job. In SQL Agent Terms a Job is a single Item, though it may have multiple steps.

    so You create a single Job, then add the composite steps normally with the ON Success set to 'Goto Next Step' (Except for the last step which is 'Quit the Job reporting Success'), and depending on requirements you can set the On Failure to either be 'Quit the Job Reporting Failure' or 'Goto Next Step'

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • October 11, 2012 at 7:09 am

    #1548080

    I agree, but It always depends on the requirements.

  • October 11, 2012 at 7:14 am

    #1548082

    sudharshan511 (10/11/2012)

    Hi all,

    Could you please tell me any one.

    My boss said to me run the four jobs in single job. How it is possible please help me some one .

    Thanks in advans

    you can add subplans ..i think...

  • October 11, 2012 at 7:47 am

    #1548116

    Or if you need 4 different jobs to run concurrently, you can add a fifth job with a TSQL job step and use

    exec sp_start_job 'job1'

    exec sp_start_job 'job2'

    exec sp_start_job 'job3'

    exec sp_start_job 'job4'

    Only the "control" job would require a schedule.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply