In order to send mail using Database Mail in SQL Server, there are 3 steps that need to be carried out.
- Create Profile and Account
- Enable DatabaseMail on SQL Server Agent
- Restart SQL Server Agent
1) Create Profile and Account
2) Enable DatabaseMail on SQL Server Agent
3) Restart SQL Server Agent