Executing sp_start_job from Package

#1

I have a package step that executes sp_start_job to start
a job... On success of that step it runs another step.
However the step assumes success upon starting the job
and the job does not actually finish before it moves to
the next step.

I currently have a sleep command at the end of the step
to give the job time to finish but how can i get the step
to not assume success until the job it calls completes?

Thanks

#2

In message <1cd8401c4224c$c9274770$a101280a (AT) phx (DOT) gbl>, Tim
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

I have a package step that executes sp_start_job to start
a job... On success of that step it runs another step.
However the step assumes success upon starting the job
and the job does not actually finish before it moves to
the next step.

I currently have a sleep command at the end of the step
to give the job time to finish but how can i get the step
to not assume success until the job it calls completes?

Thanks

Do not use a job. All job start mechanisms are asynchronous, that is one
of their benefits.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Executing sp_start_job from Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Executing sp_start_job from Package - 04-14-2004 , 01:17 PM

Re: Executing sp_start_job from Package - 04-14-2004 , 02:27 PM