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 |
|
jeffpossa
Starting Member
1 Post |
 Posted - 2010-08-27 : 06:06:46
|
| Hi All.Can Someone Help Me Out.I Have A Stored Procedure that calls msdb.dbo.[sp_send_dbmail] and sends mails.Sometimes the mail fails and not delivered to the recipients.I Know that the Mail Details Get Stored in [msdb].[dbo].[sysmail_mailitems] with sent_status = 2.Is there any way to send failed mails in SQL like a built in job.I don't want to again use msdb.dbo.[sp_send_dbmail] stored procedure.Because if it fails again, then one more entry will be added to [msdb].[dbo].[sysmail_mailitems], which I don't want. |
|
|
|
|
|
Resend Failed Database Mails