Decrease Font Size
Increase Font Size
   BLOG

Could not find stored procedure sp_help_jobhistory

by bryian 27. October 2009 18:36

Could not find stored procedure 'sp_help_jobhistory'.


sp_help_jobhistory stored procedure provides information about the cause of a job failure. If we try


EXEC sp_help_jobhistory

we will see the below error

Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'sp_help_jobhistory'.

because the sp is resided in the MSDB database.
The solution is: EXEC msdb..sp_help_jobhistory