Posted by meyvn77 on 11/10/61 11:26

I would like to know if it is possible to start a job from a stored
procedure?

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'"

OR just strat it with a stored procedure and call the stored procedure
from the adp


CREATE PROCEDURE sde.Volusia_Import AS
EXEC msdb..sp_start_job @job_name = 'Volusia_Import'
GO


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

Thanks,
Chuck

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

[Reply to this message]