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?
Microsoft DevelopmentMicrosoft SQL Server
Last Comment
Steve Samson
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
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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