This project has moved. For the latest updates, please go here.

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

Configure SQL Agent Properties

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:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSQLAgent FULL Yes Yes Yes Yes Yes
SetupSQLAgent WORKSTATION Yes Yes Yes Yes Yes
SetupSQLAgent CLIENT N/A N/A N/A N/A 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.
SSMS Agent Properties.png
2) Perform SQL Agent Properties configuration for each of the tabs given above.

Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure SQL Instance Properties Top Configure SQL Agent General Properties Next

Last edited Jun 19, 2014 at 6:31 PM by EdVassie, version 6