MaryOS


I have found out that the stored procedures sp_add_job, etc. are missing from msdb.

How do I get these procedures

Thanks, Mary




Re: SQL Server sp_add_job procedure missing

Deepak Rangarajan


You can execute the below code in someanother server which has the procedure and it will generate
the code for creating the procedure.........just execute it in the desired server and it will create it

USE msdb
go
sp_helptext sp_add_job