SQL Server Agent - E-Mails

[Fresh Air Rider]

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

[John Bell]

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

[Mike Epprecht \(SQL MVP\)]

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