Solved

Sql Server Agent Job Logs

Posted on 2014-09-03
3
316 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 45

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:ScottPletcher
ScottPletcher 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 39

Author Closing Comment

by:Kyle Abrahams
ID: 40301520
Thanks guys.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL 2012 Syntax Error 5 25
Recurring Excel Timelime for Veeam 2 35
Sql query 34 20
SQL Date Retrival 7 30
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

759 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

17 Experts available now in Live!

Get 1:1 Help Now