SQL Job Error: Failed to notify “operator” via email.

I believe it is very often for DBA(s) and Developer(s) to encounter this issue even though some of them are senior. If you are one of them, don’t worry, here is the proven approach to work out of this issue.

In order to resolve this issue, please followng these steps,

#1, Setup DB mail

#2, Configure on property of SQL Agent through SSMS windows, use DB mail you configue for SQL Agent job

#3, Create operators if you haven’t

#4, In your jobs, setup notifiation.

Done, Have fun guys. Happy Holiday.

Derek Dai @TX

Chrismas 2014