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 ?
Varshini SAsked:
Who is Participating?
PadawanDBAConnect With a Mentor Operational DBACommented:
Configure dbmail:

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:

Edit: after you create the operator, you should see the operator name in the dropdown you posted in your screenshot
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.)
Shaun KlineLead Software EngineerCommented:
I believe PadawanDBA got it right with the Operator piece.
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.