Microsoft – SQL Server Agent – Database Mail Configuration

Microsoft – SQL Server Agent – Database Mail Configuration

Please vote to effect “SQL Server Agent Configuration” changes without having to restart SQL Server Agent.

As it stands the “SQL Server Agent” has to be restarted.  This need is documented:

SQL Server Agent can use Database Mail to send e-mail messages.
http://msdn.microsoft.com/en-us/library/ms190606(v=sql.105).aspx

a) Create a Database Mail account for the SQL Server Agent service account to use.

b) Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole in the msdb database.

c) Set the profile as the default profile for the msdb database.

d) Choose Database Mail as the mail system for SQL Server Agent. For more information, see How to: Configure SQL Server Agent Mail to Use Database Mail (SQL Server Management Studio).

e) Restart SQL Server Agent.

There is a SQL Server Connect bug\suggestion asking Microsoft to please address.

The link was posted by SQLGuyCheck and the link is:

https://connect.microsoft.com/SQLServer/feedback/details/596305/database-mail-configuration

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s