DB Mail issue

Question

Hello!

Maybe I forgot something... please help me please to understand the following:

If I have some job that must notify email operator upon its (for example) failure - should these email notifications be sent (and received) if DB Mail is stopped?

In other words, if - according to the error message in the SQL Agent log - the DB Mail is not working then how do these notifications get delivered to the operator (using the sqlmail account defined in the DB Mail profile)?

Thank you in advance,
Michael

Answer 1

Hi @Hram Admin

It might be the SQL Server Agent temporarily queuing emails or using an alternate method to send notifications. Please check the Database Mail log to see if there are any queued messages.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Hello Cosmog,

Thank you for the reply!

I've already checked variouse mail-related tables and haven't found any traces of mail messages that keep being delivered to my mailbox (******@contosos1.net):

There are lots of messages in my mailbox from ******@contoso1.net while SQL Server knows nothing about them... I really don't get it... :(

Answer 3

P.S.

Maybe when DB Mail is disabled only the following will not work:

EXEC msdb.dbo.sp_send_dbmail

*@profile_name = 'SQL Database Mail',*  

*@recipients = '******@contoso1.net',*  

*@body = @fullrep,*  

*@subject = @sub;* 

Answer 4

By the way - DB Mail IS enabled, but SQL Server "thinks" that it is not: