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
>

Running a DTS PKG from a DTS PKG

Any one have an idea how to run a dts pkg from a dts pkg. I have tired the following:
use msdb
EXEC sp_start_job @.job_name = 'PITA XLS OUTPUT'
and get the error that the job does not exhist.
any ideas?
JimOriginally posted by JDionne
Any one have an idea how to run a dts pkg from a dts pkg. I have tired the following:
use msdb
EXEC sp_start_job @.job_name = 'PITA XLS OUTPUT'

and get the error that the job does not exhist.

any ideas?
Jim

HEHE my bad u cant run a dts pkg with the run job sp :)
thanx anyways
jim