October 14, 2009 at 11:51 am
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.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 14, 2009 at 12:39 pm
try EXECUTE msdb.dbo.sp_start_job @job_name = 'Property Schedule'
---------------------------------------------------------------------
October 14, 2009 at 12:45 pm
Thank you George, that worked.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 14, 2009 at 12:49 pm
pleasure greg. nice truck.
---------------------------------------------------------------------
October 15, 2009 at 12:22 pm
Yep, there are many days that I long to be back up in the bucket, splicing copper.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 5, 2013 at 6:32 pm
Worked for me as well. My job step had defaulted to the master database so it was never going to find it.
Thanks!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply