April 17, 2012 at 2:50 am
Is it possible to find out whether a job succeded or failed on a given past date which is not shown in the job history log.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
April 17, 2012 at 4:38 pm
Job history is stored in MSDB, the log you see is simply a view of the underlying tables. Restore MSDB under a different name from a backup covering the required period and look in the job hisotry tables. (You do have MSDB backups don't you?)
The relevant tables are sysjobhistory and sysjobs.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
April 19, 2012 at 1:41 am
Thank you.I have msdb backups only for this year not for the period that I want.Why would I need backup covering the actual period?Is the information stored in the tables not accumulative?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
April 19, 2012 at 8:10 am
kapfundestanley (4/19/2012)
Thank you.I have msdb backups only for this year not for the period that I want.Why would I need backup covering the actual period?Is the information stored in the tables not accumulative?
It clears the history down to keep the table sizes maintainable. If you want to change the history right click on Sql Server Agent in SSMS and go to the history option on the left. You can amend the limits on job history or just turn it off altogether.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply