I use Database Mail in SQL Server 2005 to send quite a few reports out each day. I would say that this process works fine about 99% of the time. However, once in a while, the reports don't get through to their intended recipients.
When I check into the Database Mail logs for a particular missing report, each time the log states "Mail Successfully Sent". When I had our IT Department check into the missing e-mails, they have told me that the Exchange Server never received the e-mails. By the way, I should add that all of these reports are internal to people within our domain.
I still suspect that this problem falls outside of the performance of the SQL Server, but I offered to try and do some more thorough investigation. Since the log simply states success, how do I go about digging deeper? Are there additional logging options? Retries?
My goal is to provide a higher level of reliability of delivery. Whether this means working with IT to change some functionality of Exchange or me changing SQL Server.
Any input will be greatly appreciated!