Hey, this may help someone tell me what to do:
I forgot to add the data from the cdosysmail_failures table:
There are 2 entries, both from the same date and time (when I ran it):
1. The first error has:
Source of Failure: <NULL>
Description of Failure: <NULL>
Output from Failure: <NULL>
Comment about Failure: "Failed at sp_OAMethod Send"
How would I debug the 'sp_OAMethod Send'? I'm guessing this is a stored
procedure on my SQL Server, but I don't know where it is.
2. The second error has the following:
Source of Failure: CDO.Message.1
Description of Failure: The transport failed to connect to the server.
Output from Failure: Description: The transport failed to connect to the
Comment about Failure: "sp_OAGetErrorInfo for sp_OAMethod Send"
Does this extra information help?
Could someone guide me to getting this to work?