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