Answers
Subject Date - DESC Rating Viewed Topic
Email not received by iService 1/16/2014 9:28:58 AM 4.0 2789 Email Processing
Changing the mailbox specified for messages in SMTPout 9/5/2013 10:53:53 AM None 3014 Email Processing
Article Selected >> Setting message in SMTPOut for immediate delivery
Question:
We had an issue with our SMTP server and now many messages are in the SMTPOut table waiting for delivery. However, because iService tried to send them many times the next retry date is too far out.

How can I set the date so that iService tries to deliver them right away?
Answer:
In the SMTP Out table the column "timeSent" is used to determine when to retry sending messages. When a message is first created, this value is NULL. That tells the iService Mail Processor the message has never been tried and to send immediately. You can reset this value to NULL and then the messages will be retried right away.

Once a messages is successfully handed off to an SMTP server, the value for isSent is set to 1. Therefore, you can find all messages that have NOT been sent by looking for isSent - 0.

The query below will find all unsent messages and set them for immediate delivery. Make sure you run this against the proper iService Tenant database.

UPDATE SmtpOut SET timeSent = NULL WHERE isSent = 0

Article DetailsSubscribe and Rate this article
Article ID:201476
Date Updated:2/25/2013 1:27:09 PM
# Views:3632
Article Creator:Scott Whitsitt
Article Topic:Email Processing
Attachments:-- None --
Forward Email to External Email Address - Exchange 2003 2/7/2011 4:03:12 PM None 2304 Email Processing
Testing your SMTP connection 12/10/2010 4:43:56 PM 4.0 2299 Email Processing
Setting pending messages as Sent within iService 9/7/2010 1:17:41 PM None 2402 Email Processing
Message received with a blank body 7/27/2010 3:27:17 PM 5.0 2165 Email Processing
Techniques for minimizing bounced emails 7/1/2010 9:55:45 PM 5.0 2522 Email Processing
Capturing the bounce reason from undeliverable messages 7/1/2010 5:06:59 PM None 2204 Email Processing
Options for the From email address 5/26/2010 12:38:19 PM None 2135 Email Processing
Email not leaving iService 5/19/2010 8:11:26 AM None 2065 Email Processing
Please Wait...