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 |
|
shanilash
Starting Member
17 Posts |
 Posted - 2009-05-15 : 07:09:55
|
| How can i set mail alerts using database mail if a job fails.Database mail is correctly configured |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-15 : 07:35:57
|
| Go to the job's properties page and click the Notifications section. Choose the option to Email, select the operator to receive, and select "When the job fails". |
 |
|
|
shanilash
Starting Member
17 Posts |
Posted - 2009-05-15 : 09:15:26
|
| thanks how can we test whether the mail is recieving or not... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-15 : 09:27:24
|
| There's an option on the Database Mail settings page to send a test email. You can also create a test job that does nothing and have it send email upon completion. |
|
|
|
shanilash
Starting Member
17 Posts |
Posted - 2009-05-15 : 09:32:40
|
| ya that is there...but i want to know how it work for jobs. simply how can we create job...how it will get fail |
|
|
|
shanilash
Starting Member
17 Posts |
Posted - 2009-05-15 : 09:33:30
|
| ya i understood...thanks |
|
|
|
shanilash
Starting Member
17 Posts |
Posted - 2009-05-15 : 09:53:40
|
| i created job and set the notification but it is not sending mail....test database mail is working...can u please advise me whether this will work for a distribution list.for example the mail recipent id DBA.xxx.com which includes 4 members...is there any problem wen distribution list is added |
|
|
|
shanilash
Starting Member
17 Posts |
Posted - 2009-05-15 : 10:20:56
|
| after restarting the sql server agent it worked ....thanks alot |
|
|
|
|
|
|
Database mail