Skip to content
logo Knowledgebase

What can I check if mail notifications aren't sending

Created on  | Last modified on 

Summary

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

Description

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.

Resolution

  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.

Image

Our advanced payroll software helps you stay compliant and work smarter

Sage 300 People - our powerful HR, payroll and self-service solution designed to automate reporting, streamline compliance, and transform the way you work.

I want to know more

Image