Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2007-02-26 : 17:56:36
|
| How can I set up the notification email when one of your jobs got failed using Database mail..I've already set up the database mail ... but I am not quite sure how to use the database mail to send a notification when a job failed... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-26 : 18:01:02
|
| You first need to setup an operator. They can be found in SSMS under SQL Server Agent. Once that has been setup, double click on the job in SSMS, go to Notifications, select the e-mail option and point it to your new operator.Tara Kizer |
 |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2007-02-26 : 18:12:14
|
| Thanks.. In "E-mail name:" box, do i have to type the name of profiler that I've set up in Database mail?I did setup an operator, but I am not able to send an email.. I don;t receive an email even though the job has failed..I did test "Send email" after I set up a profiler in database mail. and it worked fine..What am I doing wrong here? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-26 : 18:28:47
|
| It sounds like what you've done is correct. Perhaps the Agent needs to be restared. I'm not sure though.Tara Kizer |
|
|
|
|
|
|
Notification email on job