Database mail: Emailing one message per session

Question

Database mail: Emailing one message per session

Eliyahu

Ten Centuries

Points: 1071
More actions
May 2, 2012 at 2:49 am

#260958

I have a job that sends out emails. If I send to several emails addresses hosted on the same SMTP server, I get an SMTP error "Too many messages for this session".
Can I either configure the database mail to send one message per session?
If not, can I get the job to send one message per session?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113499 More actions · Answer 1

first off ask you smtp admins what the maximum mail per session is set at

you should be able to limit the amount of mail it sends in one go by creating a temporary mail table which has a incrementing row number and a sent flag and loop through that as you need to say selecting the top 10 where sent is false, then send the mail, mark the top 10 as sent and loop through until the mail table has nothing left to send.

Eliyahu Ten Centuries Points: 1071 More actions · Answer 2

Since the limitation comes from destination servers and we can't predict their limit, the only reliable limit will be 1 message per session.

The job has 9 steps and sends 2 emails per step plus 2 email notifications about job completion, altogether 20 emails, all to the same godaddy SMTP host. This makes me think that sending 1 message at the time won't help as long as it is done in the same job.

Scripting the job shows that all steps run in a single transaction. Can it be a factor?

Lowell SSC Guru Points: 323518 More actions · Answer 3

when i googled "godaddy SMTP host "Too many messages for this session". ", i found a couple of posts that might help;

one of them says godaddy has a limit of 250 a day:

http://support.godaddy.com/groups/email/forum/topic/send-error-in-outlook-equinetsupport-com/

The error message seems to indicate that the sending was blocked by our server. This can happen if you exceeded your SMTP relays for the day, which are 250 by default, or attempted to send more than 100 emails at once.

could you be hitting that limit?

another of them from godaddy says it depends on the setup of the email address; that is was a forward to email instead of an actual email box, you can get that error;

http://support.godaddy.com/groups/email/forum/topic/smtp-protocol-error-421-4-x-2/

I know my own host required me to pay extra, and use a different server to support email campaigns, and my limit on that s3erver is 2K per day, but it costs an extra ten bucks a month.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Eliyahu Ten Centuries Points: 1071 More actions · Answer 4

In my case godaddy just happened to be the destination. There will be hundreds of other destinations, we can neither control nor make any assumptions about them.

Ant-Green SSC Guru Points: 113499 More actions · Answer 5

just a thought but do you need to send 20 messages in one session? could you not store the individual email

bodies in one table then at the end of the job send one big email instead of sending 20 small emails.

Lowell SSC Guru Points: 323518 More actions · Answer 6

Eliyahu (5/2/2012)
In my case godaddy just happened to be the destination. There will be hundreds of other destinations, we can neither control nor make any assumptions about them.

you mean godaddy is not your SMTP server you are using for sp_sendmail?

it doesn't matter if the email was sent to @microsoft.com, it's YOUR SMTP server that is returning that error...

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Mike_GoDaddy Valued Member Points: 67 More actions · Answer 7

Lowell (5/2/2012)
when i googled "godaddy SMTP host "Too many messages for this session". ", i found a couple of posts that might help;
one of them says godaddy has a limit of 250 a day:
http://support.godaddy.com/groups/email/forum/topic/send-error-in-outlook-equinetsupport-com/
The error message seems to indicate that the sending was blocked by our server. This can happen if you exceeded your SMTP relays for the day, which are 250 by default, or attempted to send more than 100 emails at once.
could you be hitting that limit?
another of them from godaddy says it depends on the setup of the email address; that is was a forward to email instead of an actual email box, you can get that error;
http://support.godaddy.com/groups/email/forum/topic/smtp-protocol-error-421-4-x-2/
I know my own host required me to pay extra, and use a different server to support email campaigns, and my limit on that s3erver is 2K per day, but it costs an extra ten bucks a month.

To help clarify this point, the SMTP relay limit for Go Daddy email is 250 relays per day by default. This can be increased in groups of 50 relays per day up to 500 relays per day total for additional fees. However, this will only effect email sent from that email address. The error Eliyahu is receiving appears to be generated by his SMTP relay provider he is sending through. This will either be his email provider or his ISP if the ISP forces the use of their SMTP relay server to send emails.

Mike
Go Daddy® Hosting Ambassador