July 23, 2019 at 6:00 pm
After an upgrade, sql server stopped sending emails. Problem is not solved but during the breakdown some emails were not sent.
I can see them with this query:
SELECT * FROM msdb.dbo.sysmail_unsentitems;
The status is: unsent
Is there a way to sent them now that the problem is fixed?
thanks
July 23, 2019 at 7:18 pm
There are quite a few examples up here on SSC and on other blogs with sample scripts that you would want to test. I've used the one that Wayne posted up in this thread but it was quite awhile back, you'll want to test it yourself:
How to resend email in Database Mail?
Some other examples:
http://philcart.blogspot.com/2009/12/sql-2008-database-mail-resend.html
And there are many more.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply