From the past 1 week, I am not getting any email alerts from Idera SQL diagnostic manager. Our team’s group email ID is mentioned in the Tools > Alert Actions and Responses and was working fine until March 30, 2020. I clicked on the Test button to quickly perform a test to see if the email is sent successfully or not. The ‘Message sent to the SMTP Server.’ was displayed but I did not receive any mail. However, when I provided the individual email ID and tested, I am able to receive mail. I also checked whether the group email ID is active by sending a test email from the Database mail feature under management option in SQL server and the mail was successfully sent and received.
Could you please let me know what is the reason email alerts are not received for my group ID ? Are there any logs to check this further? Thanks.
The best thing to do in this situation would be to check with the team that's responsible for the email server. Whenever you perform the test with the group email address, ask the server team to see if the email server received the request. It's very possible that the issue is with the email server.
Thank you. I will ask the network admin team to check if the email server received the request. Is there any table in the SQLdmrepository and IderaDashboardRepository databases that stores the details of the mails sent from Diagnostic manager? Or does the diagnostic manager desktop client store this information ? Thanks.
Unfortunately, SQLDM doesn't keep track of when it sent an alert notification through the alert responses. It's something that just happens automatically when SQLDM determines that the conditions have been met.It does, however, put a log entry into its log file if the alert response resulted in a failure. To be specific, the log entry would be inserted into the SQLDM Management Service log file. But again, it only writes an entry if there was a failure. Given that the other alert responses with individual emails are working and the test for the group account seems to send, then I suspect that SQLDM isn't running into an error.
Thanks again for the clarification. I will involve the network admin to look into the email server.