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