What can I check if mail notifications aren't sending

how to view email notification statuses and errors in the Sage 300 People Database using SQL.

The Notification.Mail table stores all email notifications sent by the system. Each entry includes a status and an error comment if delivery fails. Status codes are:

• N = New
• D = Delivered
• E = Error
• S = Sending

The Comment column displays the error returned by the mail server, such as connection failures.

1. In SQL Server Management Studio, expand Database.
2. Expand Tables.
3. Scroll down to Notification.Mail.
4. Right-click and select Select Top 1000 Rows.
5. Edit the query by adding:
   ORDER BY DateCreated DESC
6. Check the Status column:
   • E indicates a failed notification.
7. Review the Comment column for the error details.
8. Export the data to Excel or view it directly in SQL.