Post reply

Looking for a way to create a job dependency

  • August 27, 2004 at 7:11 am

    #108595

    I’m looking for a way to create job dependencies. For example, I want “Job B” to wait until “Job A” completes before “Job B” starts. “Job B” could be on the same server, or it could be on a different server.

     

    I’m also looking for ideas no how to do holiday processing. For example, if today is a holiday, I don’t want “Job B” to run at all.

     

    Any ideas?

     

    Thanks,

     

    Jon

  • September 1, 2004 at 2:50 pm

    #521426

    I'm not sure about handling across servers, possibly master/target servers.  But you could use sp_start_job for your dependencies.  Just add a step to Job A that fires Job B using that procedure.

    As for holiday processing, you could create a holiday table, containing the dates for your special processing.  Check that table before firing Job B with sp_start_job.

    Steve

Viewing 2 posts - 1 through 2 (of 2 total)

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