Sql Server email notifications
I always seem to forget these steps when setting up the Database Mail config for job notifications.
Database mail is a 3 step process if you want it to be used to send notifications.
First set up database mail.
Second, modify the Sql Server Agent properties. Select “Alert System” and then check “enable email profile”. Select “database mail” and the profile.
Third, restart the Sql Server Agent.