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.
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: