A few undocumented steps, on top of the obvious ones, before being able to send email notifications
- Database Mail -> Configuration -> Manage profile security, make sure there is at least one public and default profile.
- SQL Server Agent -> Properties -> Alert System, make sure to check “Enable mail profile” and choose correct mail system and profile. Test button will be disabled if “Database Mail” is selected.
- Create operator
- Restart SQL Agent
Advertisement
