Decrease Font Size
Increase Font Size
   BLOG

Could not find stored procedure sp_help_jobhistory

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

Comments (1) -

  • alışveriş

    11/15/2009 5:21:56 PM |

    Thank you in advance for your quick answer !. Very nice post.

Add comment

Loading