ramana3327
SSCoach
Points: 19722
More actions
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?
arnipetursson
SSCertifiable
Points: 6557
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