Configure SQL Agent Connection Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure SQL Agent Job System Properties | Manual Configuration | Configure SQL Agent History Properties Next |
|---|
FineBuild can Configure the Connection Properties available in SSMS for the SQL Server Agent.
The SQL Agent Connection properties should not be changed from the default values shown below.
FineBuild Configure SQL Agent Connection Properties
The SQL Agent Connection 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.
Manual Configure SQL Agent Connection Properties
The following steps show what you would have to do for manual SQL Agent Connection Properties configuration. FineBuild does all of this work for you automatically.
-
Select the Connection tab
The Connection properties should not be changed from the default values shown
-
Click OK to save any changes made
Copyright FineBuild Team © 2013 - 2019. License and Acknowledgements
| Previous Configure SQL Agent Job System Properties | Top | Configure SQL Agent History Properties Next |
|---|