Configure DB Mail Profile in SQL Agent for Automated Alerts

In the recent times I have seen so many people asking the same question in MSDN forums on how do I activate database mail for the use of SQL server agent alerts system. So I am taking a chance to document it by using screen shots which can help others.

Normally what the newbies tending to do is, once they configured database mail they expect the SQL agent to use it for alerting purposes. To be clear on this part we should make sql server agent to use any one of the configured mail profiles of database mail system otherwise the agent is not going to use them

Step 1:

Configure SQL database mail system , my friend Sugesh has an article in the same site at and this explains the db mail configuration pretty much step by step so I am not covering that part.

Step2:

Right click SQL server agent and go to properties. Now select Alert system tab as shown in fig , where you can see the mail profile is disabled.

db_mail_profile_sql_agent_1

Step3:

Now enable the mail profile by ticking it and you get two options.

  • Database mail
  • SQL mail

Choose database mail as shown in figure

db_mail_profile_sql_agent_2

Step 4:

After the database mail is selected then we have to select one of the available database mail profile. I have shown LEKS as my mail profile and I have added that.

db_mail_profile_sql_agent_3

Then click OK

Step 5:

We are almost done now and the final and most important part now is to restart the SQL agent services from services.msc or SSMS or SQL configuration manager.

Leave a Reply

Leave a comment

Your email address will not be published. Required fields are marked *

*


x

Related Posts

Batch script to deploy multiple SQL files
I was working on a project where I’m supposed to deploy lots of SQL Server script files (.sql). It’s very tedious job either to manually execute ...
Configuring Alerts to Notify Policy deviations in Policy Based Management
In this article we are going to configure alerts for policy management. Alerts are triggered when a violation takes place in a particular policy ...
CSSUG October 2019 Meet
We are proud to share CSSUG is getting resumed after couple of years. All the hard work and initiation is done by Madhivanan. Thanks to Madhi fo...
powered by RelatedPosts