running a job

I have a job with 3 steps. Each step has exec sp_start_job
to kick off another job. Will the job step wait 'till th
child job is completed before going to the next step?
TIADid you try it?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Jon Templar" <anonymous@.discussions.microsoft.com> wrote in message
news:733b01c4cc24$c209fd20$a301280a@.phx.gbl...
> I have a job with 3 steps. Each step has exec sp_start_job
> to kick off another job. Will the job step wait 'till th
> child job is completed before going to the next step?
> TIA|||When you call sp_start_job from another stored proc or an application, the
sp_start_job starts the job and the SQL in the calling SP or application does
not wait for the job to finish, it just keeps going.
I would expect the same behavior for when you exec sp_start_job in each of
the steps in your SQL Job.
To simulate long running jobs, you can use the WAITFOR command.
--e.g., wait for 10 minutes
waitfor DELAY '000:10:00'
Tea C.
"Jon Templar" wrote:
> I have a job with 3 steps. Each step has exec sp_start_job
> to kick off another job. Will the job step wait 'till th
> child job is completed before going to the next step?
> TIA
>