469,890 Members | 1,691 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

SQL Server Agent - E-Mails

Hi Folks

Could anyone please tell me if there is a maximum number of E-Mails
that SQL Server Agent can send at any one time ?

I'm thinking of using it to send out matches from the database that
registered users have previously specified.

Thanks
David
Jul 23 '05 #1
2 1283
Hi

If you try and send a significant number of emails consecutively it may
overload the exchange server, you would probably better off batching them up
and sending them periodically.

John

"Fresh Air Rider" <Fr*************@Hotmail.com> wrote in message
news:55*************************@posting.google.co m...
Hi Folks

Could anyone please tell me if there is a maximum number of E-Mails
that SQL Server Agent can send at any one time ?

I'm thinking of using it to send out matches from the database that
registered users have previously specified.

Thanks
David

Jul 23 '05 #2
Hi

You real limitation is how fast your servers are and how quickly Outlook
(MAPI) can do it's work.

If you need to send a huge amount of mail, it is better to do it in an
application that uses SMTP as it is more efficient.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"John Bell" <jb************@hotmail.com> wrote in message
news:42**********************@news.zen.co.uk...
Hi

If you try and send a significant number of emails consecutively it may
overload the exchange server, you would probably better off batching them
up and sending them periodically.

John

"Fresh Air Rider" <Fr*************@Hotmail.com> wrote in message
news:55*************************@posting.google.co m...
Hi Folks

Could anyone please tell me if there is a maximum number of E-Mails
that SQL Server Agent can send at any one time ?

I'm thinking of using it to send out matches from the database that
registered users have previously specified.

Thanks
David


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Matt | last post: by
reply views Thread by Suresh | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.