Thursday, February 16, 2012

Can a job initiate another job?

How do you initiate another job from a job. Also if you can do this, if you
run two jobs from the original job can you be assured that the first job is
finished before the second is executed, the steps look like they handle this
but want to be sure.
sp_start_job can help you to start one job from another. This just starts
the job. However, it does not wait for completion of the job. You might
want to add WAITFOR and the duration to wait before the second job is
started.
-BD
"sd" <susan.dunn@.ncsl.org> wrote in message
news:OpZ68e5tEHA.1400@.TK2MSFTNGP11.phx.gbl...
> How do you initiate another job from a job. Also if you can do this, if
you
> run two jobs from the original job can you be assured that the first job
is
> finished before the second is executed, the steps look like they handle
this
> but want to be sure.
>

No comments:

Post a Comment