sql server dts: 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

In message <1cd8401c4224c$c9274770$a101280a@phx.gbl>, Tim
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

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