Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dear Lost & Found: Why can't I find "sp_add_job", et al?

Status
Not open for further replies.

BootMeUp

MIS
May 31, 2000
35
US
I need to create and run various command line jobs and decided to use &quot;sp_add_job, sp_add_jobstep, sp_start_job&quot;.&nbsp;&nbsp;Referenced in SQL Books Online with examples.&nbsp;&nbsp;Have 3 servers.&nbsp;&nbsp;These procedures aren't on any of them in 'master' or user db's.&nbsp;&nbsp;Not in extended procedures, either.&nbsp;&nbsp;Anybody know who stole 'em?<br>I could use Ent Mgr to create these, but I need to be able to run the &quot;start job&quot; on Web user's request.<br>Steve A.
 
These stored procedures are part of the SqlServer scheduling and will be found in the database 'msdb' on all of your servers.<br><br>Chris Dukes
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top