This project has moved and is read-only. For the latest updates, please go here.

Previous Configure SQL Agent Advanced Properties Manual Configuration Configure SQL Agent Job System Properties Next

Configure SQL Agent Alert System Properties

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

The SQL Agent Alert System properties should be set as shown below.

FineBuild Configure SQL Agent Alert System Properties

The SQL Agent Alert System 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 also uses the following parameters to help configure SQL Agent Alert System Properties:
Parameter Default Description
MailProfile Public DB Mail Value of DB Mail profile

Top

Manual Configure SQL Agent Alert System Properties

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

1) Select the Alert System tab.
Set the following Alert System properties:
Property Value
Replace Tokens Enabled

If DB Mail is being configured, set the following values:
Property Value
Mail system Database Mail
Mail profile MailProfile

If SQL Mail is being configured (Valid for SQL 2005 and SQL 2008 only), set the following values:
Property Value
Mail system SQL Mail
Mail profile Microsoft Exchange Settings

Alert System.png
2) Click OK to save any changes made.

Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure SQL Agent Advanced Properties Top Configure SQL Agent Job System Properties Next

Last edited Dec 22, 2014 at 4:54 PM by EdVassie, version 4