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. It applies to the Notification.Mail table.

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.

Access the Notification.Mail table

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.

 

Access the Notification.Mail table

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.

---

Sort by date

1. Edit the query by adding:
   SQL

   ORDER BY DateCreated DESC

 

 

---

Review and export data

• Check the Status column:
  • E indicates a failed notification.
• Review the Comment column for the error details.
• Export the data to Excel or view it directly in SQL.