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?
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.c om/en-us/l ibrary/ms1 74997.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).
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.
Unless you have some sort of auditing enabled on your server, it wont be really an easy thing to find out.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Outstanding found the proplenm in the job properties
right click on sql server agent -> properties -> History
You can see the default options there, usually we purge the history every 4 weeks