How to View Direct Mailer Job Errors
You can view Direct Mailer job errors to obtain more information about specific jobs or properties that do not function as expected.
Before you can view Direct Mailer job errors, you must determine which database Direct Mailer uses. To find the SQL Server name and the Database name, open Commerce Server Manager, expand Global Resources, and then click the Direct Mailer resource. In the right pane, the Direct Mailer Database connection string contains the SQL Server name (Data Source) and the Database name (Initial Catalog).
In the Connection dialog box in SQL Server, enter the values for the SQL Server name and the database name that was used by Direct Mailer.
To view Direct Mailer job errors on SQL Server
In SQL Server, expand the name of the database server that contains the Direct Mailer database.
Expand Databases, expand DirectMailer, expand Tables, right-click dml_job_errors, and then point to Open Table.
The Direct Mailer job errors are listed in the table in the right pane.