Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

job history Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 5:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:37 AM
Points: 208, Visits: 1,037
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....
Post #1386862
Posted Tuesday, November 20, 2012 5:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, November 1, 2014 6:54 AM
Points: 5,221, Visits: 5,118
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386865
Posted Tuesday, November 20, 2012 5:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:37 AM
Points: 208, Visits: 1,037
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???
Post #1386872
Posted Tuesday, November 20, 2012 6:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, October 31, 2014 11:06 AM
Points: 5,430, Visits: 10,108
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
Post #1386877
Posted Tuesday, November 20, 2012 6:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, November 1, 2014 6:54 AM
Points: 5,221, Visits: 5,118
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386878
Posted Tuesday, November 20, 2012 6:11 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 8:48 AM
Points: 323, Visits: 986
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


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1386879
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse