SQL Agent job history

Does the SQL Agent job history change if there is a modification to the job, and in what cases does an agent job purge its history?
Steve SamsonAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
It's very likely that the default settings caused SQL to purge the job history.  The default is to keep a very small total number of rows in history.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
History information can be viewd from SSMS by
right click on sql server agent -> properties -> History
 You can see the default options there, usually we purge the history every 4 weeks
0
 
PadawanDBAOperational DBACommented:
If you'd like to play around with the history in a more flexible manner than SSMS, the histories are available in the msdb table: sysjobhistory (http://technet.microsoft.com/en-us/library/ms174997.aspx).  The purge options are rather inflexible, so a lot of places will write their own sp/job to purge the history (or archive it elsewhere).
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Steve SamsonAuthor Commented:
is there a way to see if or who purged the log history? I do not purge my logs automatically.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
>is there a way to see if or who purged the log history?
Unless you have some sort of auditing enabled on your server, it wont be really an easy thing to find out.
0
 
Steve SamsonAuthor Commented:
Outstanding found the proplenm in the job properties
0
All Courses

From novice to tech pro — start learning today.