Link to home
Start Free TrialLog in
Avatar of Steve Samson
Steve Samson

asked on

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?
Avatar of Aneesh
Aneesh
Flag of Canada image

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
Avatar of PadawanDBA
PadawanDBA

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).
Avatar of Steve Samson

ASKER

is there a way to see if or who purged the log history? I do not purge my logs automatically.
>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.
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Outstanding found the proplenm in the job properties