Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2008-11-14 : 13:56:37
|
| Anyone using dbmail for large mass mailings?How are you geeting around the fact that SQL can feed the mails much faster than exchange can take then?JimUsers <> Logic |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-11-14 : 15:21:55
|
it can't  the feeling you get that it does it faster becuase they are sent to the smtp server's mail queue "faster". they still get sent one by one from the smtp server on.sql server isn't really a mass mailing system._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2008-11-14 : 17:09:17
|
| No I am actually overloading the bugger.I only got about 1000 of a 5000 set.Spaced intermittantly I got this.The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2008-11-07T12:06:12). Exception Message: Cannot send mails to mail server. (Failure sending mail.).)OrThe mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2008-11-07T12:06:12). Exception Message: Cannot send mails to mail server. (The operation has timed out.).)JimUsers <> Logic |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-11-14 : 17:10:58
|
| exactly my point._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-11-14 : 17:40:57
|
quote:
Originally posted by JimL...How are you geeting around the fact that SQL can feed the mails much faster than exchange can take then?...
You could try changing your process to send out the emails at few at a time at a rate that the email server can handle.Or get a faster email server.CODO ERGO SUM |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2008-11-14 : 17:59:37
|
| I was thinking of adding a waitfor delay in the SP to slow down the process.Funny wanting a SP to run slower.JimUsers <> Logic |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
Mass Mailings and dbmail