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
Subscribe