HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Failed to notify 'DBA Team' via email

Submitted by: @import:stackexchange-dba··
0
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.

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

Context

StackExchange Database Administrators Q#87665, answer score: 5

Revisions (0)

No revisions yet.