Configure SQL Agent History Properties
| Previous Configure SQL Agent Connection Properties | Manual Configuration | Configure Analysis Services Instance Next |
|---|
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.
The SQL Agent History Properties configuration relates to Process Id 5BE and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSQLAgent: | Yes | Yes | N/A |
| SQL2017 | /SetupSQLAgent: | Yes | Yes | N/A |
| SQL2016 | /SetupSQLAgent: | Yes | Yes | N/A |
| SQL2014 | /SetupSQLAgent: | Yes | Yes | N/A |
| SQL2012 | /SetupSQLAgent: | Yes | Yes | N/A |
| SQL2008R2 | /SetupSQLAgent: | Yes | Yes | N/A |
| SQL2008 | /SetupSQLAgent: | Yes | Yes | N/A |
| SQL2005 | /SetupSQLAgent: | Yes | Yes | 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 |
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.
-
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 
-
Click OK to save any changes made
Copyright FineBuild Team © 2013 - 2019. License and Acknowledgements
| Previous Configure SQL Agent Connection Properties | Top | Configure Analysis Services Instance Next |
|---|