sp_start_job will not work

  • 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.

  • try EXECUTE msdb.dbo.sp_start_job @job_name = 'Property Schedule'

    ---------------------------------------------------------------------

  • Thank you George, that worked.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

  • pleasure greg. nice truck.

    ---------------------------------------------------------------------

  • 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.

  • 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