Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008

    Angry Unanswered: SQL 2005 Database Mail Shutting Down

    I have setup database mail on my SQL 2005 server. It works fine. I am using it to send subscription mail. If the email addresses are good, it works fine. If there is a bad email address rather then skipping that email address, it shuts down and quits the rest of the process.

    Is there a way to configure it to log the error and move on? With SQL 2000 all it did was toss it into a queue and hope. The SMTP server dealt with the problems. Now it seems Database Mail is determining there is a problem and giving up.

    While I love the new sysmail tables that allow me to track what happened, I hate the fact the the system decides if is too frightened by an error and it needs to runaway and hide. []

    Also, does anyone know of a good resource for describing the sysmail table relationships?

    Thanks in advance for the help,

  2. #2
    Join Date
    Sep 2007
    I have a similar problem. Did you find a solution to it. Thanks

  3. #3
    Join Date
    Oct 2008

    Try This


    I faced the same problem and could solve it with the following

    Went to Server Agent Properties, then Alert System, Enable Mail Profile "Database Mail".
    Then to History and checked on Delete job history.
    Stopped and Restarted SQL Server Agent and it worked.

    I hope this helps.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts