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
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.
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.
Now enable the mail profile by ticking it and you get two options.
- Database mail
- SQL mail
Choose database mail as shown in figure
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.
Then click OK
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.