• brett.walker (12/16/2009)


    Thanks for the post. I have started implementing it but am having a problem. I seem to be having a problem finding the SP. I am getting a "Msg 2812, Level 16, State 62, Line 1

    Could not find stored procedure 'sp_help_job'." when I run this (sp_help_job @enabled = 1) in Management Studio. I have sa rights but am not sure why I'm having trouble. I am running SQL Server 2008 Standard Ed. I am not a newby at SQL Server but this is making me feel like one. 🙂

    Hi,

    The sp_help_job procedure lives in the msdb database. Do you have the msdb database selected?