Sql Server Agent Job Logs
Posted on 2014-09-03
I have a bunch of jobs on a server. Some of the jobs are not reporting any history. I'm pretty sure this is due to the fact that there's a heart beat job running on the server (runs once a minute, every minute, every day).
Is there a way to configure SQL to either (in order of preference)
1) Not log the heartbeat job
2) Limit the size of the jobs to X number of instances (eg: keep only a record of the last number of times run).
3) Expand the log size to accommodate everything
Thanks in advanced.