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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2010-07-13 : 11:19:26
|
| I've set up database mail and can right click and send test email and it works great.Then I created an operator with an email address.Then I went in to the notification tab on my JOB and set to send an email to the operator when the job succeeds .problem is that the email fails to send.The job completes fine.Date 13/07/2010 16:00:07Log Job History (MK_Nightly_Import)Step ID 0Server GOLDMINEJob Name MK_Nightly_ImportStep Name (Job outcome)Duration 00:00:07Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageThe job succeeded. The Job was invoked by User MK_Reporting. The last step to run was step 1 (Drop and recreate Tables). NOTE: Failed to notify 'ICW' via email. |
|
|
rdjabarov
Starting Member
8 Posts |
Posted - 2010-07-13 : 11:51:08
|
| Change the mail profile to PUBLIC."The data in a record depends on the Key to the record, the Whole Key, and nothing but the Key, so help me Codd." |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-07-13 : 16:25:12
|
| And - make sure the profile is set as default. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2010-07-14 : 05:44:17
|
| It is already a PUBLIC profile and it is already set to DEFAULT.What else can I look for? |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2010-07-14 : 12:11:03
|
| I've even deleted the job and recreated it. Still it doesn't work.Just to make sure I've doen it right. I don't need to have anything in the alerts populated do i . It's just the notifications is that right? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-07-14 : 16:04:38
|
| Have you configured SQL Server Agent and setup the Alert System? This needs to be configured to use Database Mail. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2010-07-16 : 04:43:47
|
| Yes.and I can right click and send test email successfully from database mail.I have set this up identically on two systems. One works but teh other doesn'tThe job succeeded. The Job was invoked by User DOMAIN\Administrator. The last step to run was step 1 (Truncate and Refill tables). NOTE: Failed to notify 'John Brown' via email. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-07-17 : 00:31:13
|
| Just because you can send database mail, does not mean SQL Server Agent has been configured to use it. You need to configure it to use Database Mail before notifications can be sent from a job. |
|
|
|
|
|
|
database mail