SQL Email Failures, Failed to notify via email, issues?
For some reason emailing of SQL Server Agent job reports stopped working when I disabled the ‘sa’ account and created a different admin user. Never could figure out why until today!
I’m not even sure if disabling the ‘sa’ account had anything to do with it because when I checked the properties of the job in question it wasn’t even configured to send alerts!
Anyway, the way I fixed it was to right click the SQL Server Agent node in SQL Management Studio and select Properties. Click the Alert System node and Enable the Mail profile you’d like to allow the SQL Server Agent to use, restart the SQL Server Agent Service (just the service, not the server!) and it should start working.