Enable server DB Mail

Problem

To use DB Mail to send emails from SQL Server as well as job notifications, DB Mail needs to be configured with a public and default profile, as well as smtp and email.

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_setup_server_db_mail.sql

Example