i had a job on my client database which is running every 3 minutes to send out all my mail item list using Database Mail.
This job will automatically send out email which is retrieve from one of my table (DocumentQueue).
So whenever user click "Email" button on my system, system will add record on my table (DocumentQueue)
and every 3 minutes my job will started to send out all email in DocumentQueue which is not being send.
What my problem is... the recipient on my table in the wrong format, ie: firstname.lastname@example.org;stone.wu@g;
And this email is being send on 09:00.
It keeps sending email every 3 minutes...
on the 1st 10 minutes the errors on sysmail_log was :
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-10-04T09:28:00). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail
and after 10 minutes the errors was :
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-10-04T12:42:00). Exception Message: Could not connect to mail server. (An operation on a socket could not be performed because the system
View Complete Post