2/21/2023 0 Comments Enable smtp automailer![]() You can check these views for problems with specific emails to see whether database mails are being sent, are stuck in the queue, or fail to be sent. Step 2: Check sysmail_unsentitems, sysmail_sentitems, and sysmail_faileditems views When an error is returned from sp_send_dbmail, the email isn't submitted to the Database Mail system and the error isn't displayed in the sysmail_event_log view. To search for errors that are related to specific emails, look up the mailitem_id of the failed email in the sysmail_faileditems view, and then search for messages that are related to mailitem_id in sysmail_event_log. If there are no problems with Database Mail external executable, go to the sysmail system views.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |