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 PletcherSenior 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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.