Send an email when a job fails

Question

Hi All

 

I am new to sql 2005 and need to set up an email notification when a job fails, but i need to send it multiple users.

 

I have about 25 differenent jobs and i know i can set up a email on failure within each job but it can only be to one person.

So what i have done is set up the 5 operators and want i wanted to do is setup an alert to capture when a job fails and sends it to everyone on the response list.

 

I have configured the email and that works ok as i have setup an alert when a invalid login occurs.

 

Thanks in advance

 

Rich

Answer 1

• Before using the operator you need to database mail to send mail using this one. Check the link "Database Mail" to configure database mail
• Once this done, Go to the respective job property
• In the left pane of the job property you have Notifications tab, click on that
• In that page click on E-mail (i.e on check box), next select operator drop down menu and select the operator, next select "When the job fails" and click on OK.
  Proceed these steps for all the jobs, so that when the job fails the operator will be notified via mail.

Answer 2

Before that you have to confi the SMTP

The Next goto DATABASE MAIL

---

LeelaK

Answer 3

• Before using the operator you need to database mail to send mail using this one. Check the link "Database Mail" to configure database mail
• Once this done, Go to the respective job property
• In the left pane of the job property you have Notifications tab, click on that
• In that page click on E-mail (i.e on check box), next select operator drop down menu and select the operator, next select "When the job fails" and click on OK.
  Proceed these steps for all the jobs, so that when the job fails the operator will be notified via mail.

I'm new to this, I learned a lot from what you said.