Configure SQL Agent Properties - SQL-FineBuild/Common GitHub Wiki

Previous Configure SQL Instance Properties Manual Configuration Configure SQL Agent General Properties Next

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

The operation of the SQL Agent is controlled by a number of properties. Some of these need to be set to obtain maximum performance and stability. The propertiies available on each of the Tabs on the SSMS Agent Properties dialogue are dealt with separately.

Item Comment
Configure SQL Agent General Properties Configure SQL Service restart properties
Configure SQL Agent Advanced Properties Review SQL Agent Advanced properties
Configure SQL Agent Alert System Properties Configure SQL Agent Alerting
Configure SQL Agent Job System Properties Review SQL Agent Job System properties
Configure SQL Agent Connection Properties Review SQL Agent Connection properties
Configure SQL Agent History Properties Extend retention of SQL Agent job history data

FineBuild Configure SQL Agent Properties

The SQL Agent 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 will automatically perform SQL Agent Properties configuration for each of the Items given above.

Top

Manual Configure SQL Agent Properties

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

  1. Use SQL Server Management Studio to connect to the SQL instance

    Right-click on the SQL Agent and select Properties

    ![SQL Agent Properties](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureSQLAgentProperties/SSMS Agent Properties.png)

  2. Perform SQL Agent Properties configuration for each of the tabs given above

Copyright FineBuild Team © 2013 - 2019. License and Acknowledgements

Previous Configure SQL Instance Properties Top Configure SQL Agent General Properties Next