Home Forums SQL Server 2005 T-SQL (SS2K5) Starting a Job RE: Starting a Job
Lynn Pettis
SSC Guru
Points: 442467
More actions
December 15, 2008 at 2:41 pm
#912818
You will find it here: msdb.dbo.sysjobs
If you use the job_id, if they drop and recreate your job, the procedure will also break.
Best thing to do is document your job and that it is executed from your specified stored procedure.