Previous Configure SQL Agent Connection Properties Manual Configuration Configure Analysis Services Instance Next

Configure SQL Agent History Properties

FineBuild can Configure the History Properties available in SSMS for the SQL Server Agent.

The SQL Agent History properties should be set as shown below.

FineBuild Configure SQL Agent History Properties

The SQL Agent History Properties configuration relates to Process Id 5BE and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSQLAgent FULL Yes Yes Yes Yes Yes
SetupSQLAgent WORKSTATION Yes Yes Yes Yes Yes
SetupSQLAgent CLIENT N/A N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigSQLAgent can also be used.

FineBuild also uses the following parameters to help configure SQL Agent History Properties:
Parameter Default Value Description
AgentMaxHistory 20000 Maximum number of history rows to be kept for all Jobs
AgentJobHistory 500 Number of history rows to be kept for a single Job

Top

Manual Configure SQL Agent History Properties

The following steps show what you would have to do for manual SQL Agent History Properties configuration. FineBuild does all of this work for you automatically.

1) Select the History tab.
Set the following History properties:
Property Value
Maximum job history log size AgentMaxHistory value
Maximum job history rows per job AgentJobHistory value

History.png
2) Click OK to save any changes made.

Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure SQL Agent Connection Properties Top Configure Analysis Services Instance Next

Last edited Dec 22, 2014 at 3:55 PM by EdVassie, version 6