sp_add_job
Database
3
Posts
2
Posters
0
Views
1
Watching
-
Very simple question: I have SQL 2000 installed, but don't seem to have a procedure sp_add_job: ... EXEC sp_add_job go .... Msg 2812, Level 16, State 62, Server PEER170, Line 1 Could not find stored procedure 'sp_add_job'. ... what have I missed?
cheers, Neil
-
Very simple question: I have SQL 2000 installed, but don't seem to have a procedure sp_add_job: ... EXEC sp_add_job go .... Msg 2812, Level 16, State 62, Server PEER170, Line 1 Could not find stored procedure 'sp_add_job'. ... what have I missed?
cheers, Neil
This proc is in msdb, not master. did you drop msdb?
-
This proc is in msdb, not master. did you drop msdb?
Nope, just didn't realise it was located there. Thanks for your help.
cheers, Neil