Posted by Erland Sommarskog on 10/09/02 11:26

(meyvn77@yahoo.com) writes:
> I would like to know if it is possible to start a job from a stored
> procedure?

Yes. As long as you have the privileges.

> I have a DTS that I set as a job and would like to either call it from
> an ADP with
>
> Conn.Execute "EXEC msdb..sp_start_job @job_name = 'Volusia'"

Maybe better to add an adExecuteNoRecords? This could be the reason
you don't see any error message.

> I tried both of these and it does not give me an error but it does not
> run the job... what am I missing?

And SQL Server is running?

Have you checked in job history that the job is not terminating directly?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Help with calling a job from Stored P and VBA......HELP
• Prev in forum: Re: Help with calling a job from Stored P and VBA......HELP
• Thread view: Re: Help with calling a job from Stored P and VBA......HELP

[Reply to this message]