Post reply

Job History

  • October 30, 2014 at 8:53 pm

    #312214

    Hi,

    Is it possible to find the 1 yr history of a particular job in sql server?

  • October 31, 2014 at 9:37 am

    #1756065

    Job history settings limit total rows in sysjobhistory and number of rows for any given job.

    If you have an old backup of msdb, you could restore it with a different name and look in msdb.dbo.sysjobhistory?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply