April 23, 2015 at 12:27 pm
We recently had a problem with DB Mail. SQL jobs that sends an email succeeded but the email in the job fail to sent. There was a problem with the email server. The error is included. We fixed the problem with the email server. How can I get an alert when a DB Mail email fails send?
------------------------------------------
Date4/23/2015 10:01:06 AM
LogDatabase Mail (Database Mail Log)
Log ID5907
Process ID13204
Mail Item ID5702
Last Modified4/23/2015 10:01:06 AM
Last Modified Bysa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-04-23T10:01:06). Exception Message: Cannot send mails to mail server. (Insufficient system storage. The server response was: 4.3.1 Unable to accept message because the server is out of disk space.).
)
April 23, 2015 at 1:02 pm
What kind of an alert do you want? An email would be great here, but the message is that you can't send an email due to lack of disc space. Kind of a Catch-22.
I could think of some kludgy alternative alerts, but email's really the best way to do it. What can you do to ensure that the email server stays unfilled?
Sigerson
"No pressure, no diamonds." - Thomas Carlyle
April 23, 2015 at 1:09 pm
also, note the error is at the SMTP mail server you sentto, and might not have anything to do with you (unless you own the mail server that it was sent to)
that server limits them to x megs of space; if the desitnation email's mailbox is full, they reject more emails. not much you can do about a third parties rules on storage space..
Lowell
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply