How to setup a SQL Job failure notification by email ?

I can able to send email through Database mail. But I am not able to configure the
Job failure notification email since it is empty. (Please see my attachement).

How to configure the SQL job failure notification  email ?
notification.png
Varshini SAsked:
Who is Participating?
 
PadawanDBAOperational DBACommented:
Configure dbmail: http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Enable mail profile: Right click sql server agent > Properties > Alert System > Check "Enable mail profile" and then select the mail profile you made above

Create an operator: http://technet.microsoft.com/en-us/library/ms175962(v=sql.105).aspx

Edit: after you create the operator, you should see the operator name in the dropdown you posted in your screenshot
0
 
Shaun KlineLead Software EngineerCommented:
Have you configured an account and profile in the Database Mail feature? (Seems a silly question, but I believe you can send database mail through code without performing these steps.)
0
 
Shaun KlineLead Software EngineerCommented:
I believe PadawanDBA got it right with the Operator piece.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.