March 17, 2022 at 10:34 am
Hello,
I have sent automatic mail after certain operations using the database mail feature of SQL Server.
It has been working flawlessly for years. We haven't made any changes to our structure.
The server cannot send emails since 2022-03-09 22:41:30.630.
The updates that the server has received since that date are attached.
Also when I run DatabaseMail.exe I get the following error.
After some research on the internet, I found the following topics.
https://www.sqlservercentral.com/forums/topic/database-mail-items-stuck-in-unsent-status
But we did not remove or re-install netframework on the server. So we've had no business on the server until now. I don't know if there was netframework 3.5 before.
I am sending test mail, it is queued. It is not written in a log as an error. In fact, we created a mail profile that does not exist at all, let's see if there is an error in the log. There are no errors in the logs. In other words, I cannot see the error of any operation in the database mail logs.
When I run the below query, I see sent_status as unsent.
SELECT top(100) sent_status,* FROM msdb.dbo.sysmail_allitems
March 18, 2022 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 22, 2022 at 11:50 am
Hi,
take a look at this topic:
https://www.sqlservercentral.com/forums/topic/database-mail-not-working-after-sql-server-2016-sp3
Kind regards,
Andreas
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply