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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-07-01 : 07:32:28
|
| VJ writes "Hi, We are using SQL email. We use a job to create and send email every 10 minutes. The problem is every 1 to 2 months the SQL server message queue won't clear by itself and keeps sending the same email repeatedly annoying our customers. Every time it happens we have to manually clear the Queue or we have to reboot the server to clear it up. Please advice if there is a better way to handle this?.Please respond to the abocve mentioned email id.Thanks.VJ" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-01 : 12:34:58
|
| You haven't given us enough information. Are you using xp_sendmail to send the e-mail? What e-mail client are you using (Outlook 2000, 2002)? Where are you clearing out the queue?Tara |
 |
|
|
|
|
|