October 30, 2003 at 7:09 am
We are running SQL2K and when I try to run sp_start_job it replies: Could not find stored procedure 'sp_start_job'.
In fact it can't find any of the SQL Server Agent Procedures. It can find the Profiler Procedures, Mail Procedures, Security Procedures, etc. but not the Agent Procedures. What's up with that?
October 30, 2003 at 7:10 am
It should be in MSDB database.
October 30, 2003 at 7:15 am
Thank you!
Next question. I want to build a dts package that will run a .cmd file I have on the hard drive. What's the best way to do that?
October 30, 2003 at 7:25 am
Use DTS to run Execute Process Task to call the cmd file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply