|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
SQL2k5 sp2
I've setup db mail on a box and it seems to work fine. I can send a test email by right-clicking on the db mail folder, and I can send a test using sp_send_mail. However, when I setup a test job that will always fail, the history of the job says it "failed to notify operator...". When I check the db log it says this: 07/05/2007 16:38:53,,Error,5,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-07-05T16:38:53). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.). ),1272,2,,7/5/2007 4:38:53 PM,sa What string is it referring to? I used the same email address I used to send a test email in both examples I described above. Thanks, Andre |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
I just changed the job to be owned by "sa" instead of me and when I ran it
this time, it sent an email. The strange thing is that I'm a member of the Administrators Group on this server. So there must be something about DB Mail and who the job's owner is - correct? Any information that can be shared about this would be appreciated. Andre |
|
![]() |
| Outils de la discussion | |
|
|