sp_start_job

Last Post 31 Dec 2005 12:05 PM by rambuyer. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Len_SQL
New Member
New Member

--
02 Aug 2004 01:52 PM
Hi,
I'd like to be able to pass parameters to the stored procedures encapsulated in a job.
The job will be invoked using the stored procedure sp_start_job.
Is it possible to pass the paratemeters dynamically to the encapsulated procedure?
Thank you,
Len
rambuyer
New Member
New Member

--
31 Dec 2005 12:05 PM
If you create a Stored Procedure that calls the others, then you could refence that procedure in your job, or you could just call the new stored procedure instead of running the job.


Acceptable Use Policy
---