patternsqlMinor
Failed to notify 'DBA Team' via email
Viewed 0 times
notifyemailteamviafaileddba
Problem
I setup a test job to test out my failure notifications and now I'm getting the following error, stating it did not notify my operator via email. The strange thing is I ran the same exact setup script on several other instances and it worked just fine, but is failing on this instance. I checked the properties for SQL Server Agent and the operator itself. I also sent myself a test email from the Management branch's Database Mail and it worked successfully.
Failed to notify 'DBA Team' via email.
Failed to notify 'DBA Team' via email.
Solution
Ensure you've enabled Mail Session in SQL Server Agent.
SQL Server Agent > Properties > Alert System: Check Enable mail profile.
This link should help:
Avoiding failed notified operator email errors
SQL Server Agent > Properties > Alert System: Check Enable mail profile.
This link should help:
Avoiding failed notified operator email errors
Context
StackExchange Database Administrators Q#87665, answer score: 5
Revisions (0)
No revisions yet.