To enable the database email service in SQL Server, you need to take a few steps to configure in your database. The benefits of enabling this service are you can automate emails for query results, job success or failures or even trigger emails based on table changes in your system, great for notifications.
First of all, you will need a valid email address, and the SMTP details for your organisation. The email administrator for your organisation can help you with this.
Configure SQL Server database email
- Open your database in SQL Management Studio and navigate to “Management > Database Mail”. Right-click and selected “Configure database mail”
2. You will now see the database mail configuration wizard.
3. Select the first option to set up database mail by performing tasks including SMTP and profile security.
4. Create a profile name, then click “Add” to add a new account. In the new pop-up window click “New Account” and proceed to complete the valid email account and SMTP server details you have previously checked with your organisations email administrator. Once complete click “Next”.
5. On the next screen simply check the new profile you created and click “Next”.
6. The next screen allows you to configure your email parameters, such as number of retries if an email delivery fails and logging settings. Click “next” when complete and then “finish”.
This completes the configuration for your SQL Database Mail, and you can go on and create your own scripts to utilise this awesome feature.
Phil's learning log 
One thought on “Setting up SQL Server database email”