Solved

Sql Server Agent Job Logs

Posted on 2014-09-03
3
320 Views
Last Modified: 2014-09-03
Hi All,

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.
0
Comment
Question by:Kyle Abrahams
3 Comments
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 350 total points
ID: 40301393
3)  Expand the log size to accommodate everything

In SSMS go to SQL Server Agent and right-click for properties and make the changes you need in History.
Capture.PNG
0
 
LVL 69

Assisted Solution

by:Scott Pletcher
Scott Pletcher earned 150 total points
ID: 40301428
I prefer to uncheck the "Limit size" and specify a "Remove agent history" time period.  You can specify 3 months if you want.  That keeps all history for a full three months, rather than a raw row count, which could of course be inflated by frequently run jobs.
0
 
LVL 40

Author Closing Comment

by:Kyle Abrahams
ID: 40301520
Thanks guys.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now