Greetings all. I am trying to write a procedure that will run a DTS package. I have found many posts here, many of which point to sp_start_job. So, I scheduled a job, deleted the schedule for it, and am trying to run it by using the below, which is how it is in BOL.
EXECUTE sp_start_job @job_name = 'Property Schedule'
However, when I try to execute this, I get...
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_start_job'.
Is there some configuration I need to set? BOL does not offer much insight for this one. Thanks all.
The glass is at one half capacity: nothing more, nothing less.