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

 

  

Advertisements

Published by

Derek Dai

focusing DB, Big Data and BI tech.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s