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 |
|
jmcl
Starting Member
6 Posts |
 Posted - 2007-04-16 : 09:22:09
|
| I had a very recent problem where an excess number of mail records were queued. I ran sysmail_delete_mailitems_sp and deleted them from the InternalMailQueue, but it looks like they still exist in the ExternalMailQueue as I keep getting messages in the log similar to "Mail Id 2277459 has been deleted from sysmail_mailitems table. This mail will not be sent". The MailItem_Id keeps incrementing so it looks like it's working its way through. The problem is we can't use it to sent current mail until it gets through about another 3 million records. If there is some way to delete those records from the External Mail Queue or fast-forward the system to the current records that would be very helpful. Any ideas?John |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-04-16 : 09:45:14
|
| Do not cross postCODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-16 : 14:04:01
|
| Sorry, MVJ, but that isn't helpful. You have posted that on both the OP's posts, and I, and others I suspect, have no idea which one will be suitable for the colective answers.Can I respectfully suggest that you post a "Duplicate post http://url" on all-bar-one of the posts, and then folk like me encountering a duplicate will be guided to a single thread where we can devote our energies.Kristen |
|
|
|
|
|
|
Delete Queued Mail