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