Configure SQL Agent Advanced Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure SQL Agent General Properties | Manual Configuration | Configure SQL Agent Alert System Properties Next |
|---|
FineBuild can Configure the Advanced Properties available in SSMS for the SQL Server Agent.
The SQL Agent Advanced properties should not be changed from the default values shown below.
FineBuild Configure SQL Agent Advanced Properties
The SQL Agent Advanced 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 Advanced Properties
The following steps show what you would have to do for manual SQL Agent Advanced Properties configuration. FineBuild does all of this work for you automatically.
-
Select the Advanced tab
The Advanced 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 General Properties | Top | Configure SQL Agent Alert System Properties Next |
|---|