Database Mail fails at email server alert

  • 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.).

    )

  • 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

  • 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply