Answers
Subject Date - DESC Rating Viewed Topic
How do I configure IIS to forward all HTTP requests to HTTPS? 10/26/2016 11:29:17 AM None 1800 Site configuration
simple user login check for iService forms 2/4/2016 8:58:06 AM None 1598 Technical Support
Changing the Message Queue actions to the custom portal form 1/22/2016 5:40:23 PM None 1581 Technical Support
Updating the Message Queue page to the new version in 7.4 1/22/2016 5:24:29 PM None 2239 Site configuration
Making a form to display an interaction body or other details 8/27/2015 1:32:18 PM None 1715 Technical Support
Considerations when setting up a service account to run utilities 7/3/2015 4:51:20 PM None 2418 Batch Utility
Customer did not receive an iService email 8/7/2014 9:12:48 AM 4.0 2026 Technical Support
Updating agent count for on-premise installations 7/7/2014 11:59:40 AM 4.5 2747 Site configuration
How do I create a report subscription? 6/23/2014 11:26:47 AM None 2615 Reports
Disabling browser cache to force current data into your screen 6/13/2014 10:26:28 AM None 1059 All Topics
Setting mailbox for reuse later 4/10/2014 9:57:12 AM None 1942 Technical Support
Chat interface is mistakenly displayed when I login using Internet Explorer 3/11/2014 9:57:20 AM None 2066 Technical Support
When I log in, I don't see the Message Queue tab 2/24/2014 11:56:11 AM 4.0 2103 Technical Support
Email not received by iService 1/16/2014 9:28:58 AM 4.0 2783 Email Processing
Changing the mailbox specified for messages in SMTPout 9/5/2013 10:53:53 AM None 3011 Email Processing
iService 5.x fails to load with the error "Unrecognized configuration section system.serviceModel in machine.config" 6/18/2013 3:31:05 PM None 1445 All Topics
Impact of iService On-demand on your IT department 5/21/2013 9:51:43 AM None 3086 Security
Creating an agent from an existing contact 3/26/2013 2:36:46 PM 4.0 3196 Security
Ensuring that SPAM contacts are not mislabeled and steps to correct 3/19/2013 3:22:32 PM None 2388 Technical Support
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:3628
Article Creator:Scott Whitsitt
Article Topic:Email Processing
Attachments:-- None --
JQuery Mobile and iService Forms 1/13/2013 1:24:26 PM None 3452 Customizing iService
Simple example for filtering messages to a new topic 12/18/2012 3:39:34 PM 5.0 3389 Site configuration
Lost password, administrator forwarding link 12/4/2012 8:48:19 AM 5.0 2387 Technical Support
iService Business Intelligence and Reports Documentation 8/1/2012 10:52:21 AM 4.0 3197 Reports
List of bookmarks/favorites to common tasks 4/7/2012 10:24:15 AM 4.0 2535 Technical Support
Please Wait...