Job History entries clearing down by itself
-
We need to keep at least 1 months worth of daily jobs to be recorded in the job history for auditing and Change control purpose.
Is there a config for this as the entries are cleared by the system somehow.
Thanks in advance. Ram
-
check your sqlagent properties/ jobsystem and raise the jobhistory lines.
afaik there is no way of stating that each job should retain at least the last month or n-days of execution history.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks alzdba, really appreciate it. Regards -
You might also consider creating a job to copy the log lines from msdb..sysjobhistory to another table for the items you have to maintain.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply