• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 604
  • Last Modified:

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
0
Varshini S
Asked:
Varshini S
  • 2
1 Solution
 
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
 
PadawanDBACommented:
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:
I believe PadawanDBA got it right with the Operator piece.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now