We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
COURSE of the MONTH
11 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL Server - Email Fails
Posted on 2016-09-04
Dear All
I have created a New SP that is iterating (Cursor) a Project table and extracting the list of Email address, then sending the specific data to all the Project Email address.
This SP is scheduled in one of the Job to run on every Sunday morning while no other process is going on.
While Email are triggering, But not for all projects. What I mean is that out of 10 valid projects, 1 or two triggers and deliver to recipients but for all other fails.
I checked the Log File and observed the Error :
the mail could not be sent to the recipients because of the mail server failure. cannot send mails to mail server. (failure sending mail.).
Please suggest how may I fix the issue,
according to my analysis and doubt, it looks like that due to Looping, the mail server may gets exhausted, resulting in failure. If this is the case, how may I delay the Loop process OR how may I increase the time delay?
regards
I have created a New SP that is iterating (Cursor) a Project table and extracting the list of Email address, then sending the specific data to all the Project Email address.
This SP is scheduled in one of the Job to run on every Sunday morning while no other process is going on.
While Email are triggering, But not for all projects. What I mean is that out of 10 valid projects, 1 or two triggers and deliver to recipients but for all other fails.
I checked the Log File and observed the Error :
the mail could not be sent to the recipients because of the mail server failure. cannot send mails to mail server. (failure sending mail.).
Please suggest how may I fix the issue,
according to my analysis and doubt, it looks like that due to Looping, the mail server may gets exhausted, resulting in failure. If this is the case, how may I delay the Loop process OR how may I increase the time delay?
regards
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
6 Comments
Hi musalman,
The following is how in T-SQL one does a 5 second wait
Try and do some investigation on the mail server(look for relevant logs) to try and fully understand where the failure is and what exactly the failure is.
The following is how in T-SQL one does a 5 second wait
WAITFOR DELAY '00:00:05'
Try and do some investigation on the mail server(look for relevant logs) to try and fully understand where the failure is and what exactly the failure is.
Active 1 day ago
How many mails are sent per execution?
This seems to be primarily a mail server failure, thus you should take a look at the mail server logs.
This seems to be primarily a mail server failure, thus you should take a look at the mail server logs.
ste5an:
There are 3-7 email addresses per execution, so where ever less, might be getting success!
Barry Cunney:
I will first use the delay methof for 10 - 20 sec, if this works, then nothing to check, If still it misbehaves, I need to look into the logs,
However, I am not sure how to check the logs further in detail ...
Regards
There are 3-7 email addresses per execution, so where ever less, might be getting success!
Barry Cunney:
I will first use the delay methof for 10 - 20 sec, if this works, then nothing to check, If still it misbehaves, I need to look into the logs,
However, I am not sure how to check the logs further in detail ...
Regards
Barry Cunney: :
After adding a Delay of 20 sec, it seems that all the Email status is appearing as Sent in the sysmail_allitems table.
Tomorrow. I will check with the recipients, and will revert back for any comments.
Thanks for the support.
After adding a Delay of 20 sec, it seems that all the Email status is appearing as Sent in the sysmail_allitems table.
Tomorrow. I will check with the recipients, and will revert back for any comments.
Thanks for the support.
Active 1 day ago
Sounds like an anti-spam delay on your mail server. Check the configuration, whether you can disable it for you SQL Servers IP.
Featured Post
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Course of the Month11 days, 10 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.