Layton ServiceDesk - Troubleshooting - Outgoing Email Stops
(New page) |
(Added section "Bulk Delete") |
||
Line 1: | Line 1: | ||
+ | =Basic Remedy= | ||
Usually this is due to unusual characters in an email. If outgoing mail ever stops, here is the immediate remedy: | Usually this is due to unusual characters in an email. If outgoing mail ever stops, here is the immediate remedy: | ||
Line 12: | Line 13: | ||
4. Here you can see that the earliest email could not be sent. Click the Delete button for that email and confirm. The rest of the emails should now be sent. If not, you can delete the now-earliest. Don't delete more than three emails, as this could indicate a different issue, most likely a misconfiguration of [[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|email settings]]. | 4. Here you can see that the earliest email could not be sent. Click the Delete button for that email and confirm. The rest of the emails should now be sent. If not, you can delete the now-earliest. Don't delete more than three emails, as this could indicate a different issue, most likely a misconfiguration of [[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|email settings]]. | ||
+ | |||
+ | =Bulk Delete= | ||
+ | If the list is full of failed emails, you can quickly eliminate all email with this SQL query: | ||
+ | |||
+ | TRUNCATE TABLE [LaytonServiceDesk].[dbo].[mail] | ||
+ | |||
+ | If you are getting many failures, check the [[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|email settings]]. | ||
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p> | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p> |
Revision as of 05:32, 30 September 2013
Basic Remedy
Usually this is due to unusual characters in an email. If outgoing mail ever stops, here is the immediate remedy:
1. Go to Administration > System Settings > Email Server Settings.
2. Click the View Pending Outgoing Emails link.
3. A list of outgoing emails will appear:
4. Here you can see that the earliest email could not be sent. Click the Delete button for that email and confirm. The rest of the emails should now be sent. If not, you can delete the now-earliest. Don't delete more than three emails, as this could indicate a different issue, most likely a misconfiguration of email settings.
Bulk Delete
If the list is full of failed emails, you can quickly eliminate all email with this SQL query:
TRUNCATE TABLE [LaytonServiceDesk].[dbo].[mail]
If you are getting many failures, check the email settings.