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 1689 Site configuration
simple user login check for iService forms 2/4/2016 8:58:06 AM None 1547 Technical Support
Changing the Message Queue actions to the custom portal form 1/22/2016 5:40:23 PM None 1525 Technical Support
Updating the Message Queue page to the new version in 7.4 1/22/2016 5:24:29 PM None 2137 Site configuration
Making a form to display an interaction body or other details 8/27/2015 1:32:18 PM None 1651 Technical Support
Considerations when setting up a service account to run utilities 7/3/2015 4:51:20 PM None 2333 Batch Utility
Customer did not receive an iService email 8/7/2014 9:12:48 AM 4.0 1967 Technical Support
Updating agent count for on-premise installations 7/7/2014 11:59:40 AM 4.5 2677 Site configuration
How do I create a report subscription? 6/23/2014 11:26:47 AM None 2543 Reports
Disabling browser cache to force current data into your screen 6/13/2014 10:26:28 AM None 1013 All Topics
Setting mailbox for reuse later 4/10/2014 9:57:12 AM None 1859 Technical Support
Chat interface is mistakenly displayed when I login using Internet Explorer 3/11/2014 9:57:20 AM None 2015 Technical Support
When I log in, I don't see the Message Queue tab 2/24/2014 11:56:11 AM 4.0 2049 Technical Support
Email not received by iService 1/16/2014 9:28:58 AM 4.0 2696 Email Processing
Changing the mailbox specified for messages in SMTPout 9/5/2013 10:53:53 AM None 2940 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 1400 All Topics
Impact of iService On-demand on your IT department 5/21/2013 9:51:43 AM None 2995 Security
Creating an agent from an existing contact 3/26/2013 2:36:46 PM 4.0 3123 Security
Ensuring that SPAM contacts are not mislabeled and steps to correct 3/19/2013 3:22:32 PM None 2207 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:3210
Article Creator:Scott Whitsitt
Article Topic:Email Processing
Attachments:-- None --
JQuery Mobile and iService Forms 1/13/2013 1:24:26 PM None 3316 Customizing iService
Simple example for filtering messages to a new topic 12/18/2012 3:39:34 PM 5.0 3251 Site configuration
Lost password, administrator forwarding link 12/4/2012 8:48:19 AM 5.0 2263 Technical Support
iService Business Intelligence and Reports Documentation 8/1/2012 10:52:21 AM 4.0 3139 Reports
List of bookmarks/favorites to common tasks 4/7/2012 10:24:15 AM 4.0 2384 Technical Support
Please Wait...