November 20, 2012 at 5:39 am
hello experts,
if i remove job history in every 2 weeks, is there any way to get information of any job step which has executed 1 month back. any work around ??? please let me know....
November 20, 2012 at 5:43 am
Do you have backups of MSDB going back 1 month? If so restore it as a user database, then query sysjobhistory via script.
If you do not have backups of MSDB then unless you do custom logging of your job steps there is no way to get this information back.
November 20, 2012 at 5:53 am
anthony,
we dont have backup of msdb, and as far as i know there is no setup of custom logging, if we want to do so please let me know how to do custom logging???
November 20, 2012 at 6:06 am
First of all, why aren't you backing up msdb? Second, if you know you're going to want to access job history from a month ago, then maintain the data in msdb accordingly. I can't see any value in setting up custom logging when the information is already there for you.
John
November 20, 2012 at 6:06 am
First off, why no backups? System database are just as important to backup as your user backups. Please tell me you backup your Master database at least?
Second on custom logging, you would setup steps in your job to write to a table in a user database saying I did this, I did that, or nightly pull information from msdb.dbo.sysjobhistory into a table in a user database so you have a complete history, but if you do that and you know you need to go back 1 month, then just make MSDB store 1 months worth of data.
November 20, 2012 at 6:11 am
anthony.green (11/20/2012)
First off, why no backups? System database are just as important to backup as your user backups. Please tell me you backup your Master database at least?
+10000000
-----------------------------------------------------------------------------
संकेत कोकणे
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply