Start a job from DTS?

#1

Is there a way to start a job from DTS? I want to kick
off another job (not another DTS script) at the end of my
DTS script.

Thanks for your help,

Erik
erik (AT) klein (DOT) ca

#2

You should be able to use an executesql task and issue sp_start_job.

--

Andrew J. Kelly
SQL Server MVP

"Slim Ediddy" <erik (AT) klein (DOT) ca> wrote

Quote:

Is there a way to start a job from DTS? I want to kick
off another job (not another DTS script) at the end of my
DTS script.

Thanks for your help,

Erik
erik (AT) klein (DOT) ca

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

Start a job from DTS?

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

Start a job from DTS? - 07-08-2003 , 06:41 AM

Re: Start a job from DTS? - 07-08-2003 , 07:17 AM