Direct Mailer: Discovering details of job failures

When a Direct Mailer job completes, Direct Mailer logs an event to the application event log. This event contains the job number, the start time of the job, the completion time of the job, the number of total recipients in the mailing, and the number of errors that occurred.

To find more information about the failures, you need to look in the dml_job_errors table in the Direct Mailer database.

Solution

Open Event Viewer and locate the application event log message logged by Direct Mailer.

To open Event Viewer

  1. Click Start, point to Programs, point to Microsoft Commerce Server and then click Commerce Server Manager.

  2. Expand the Event Viewer node and double-click Application.

  3. In the events list, find the event where the Source is Commerce Server Direct Mailer, and the Event ID is 18.

  4. Double-click the event message to open the Event Properties dialog box.

  5. In the Event Properties dialog box, copy the job number onto Microsoft Clipboard, and then open SQL Server Query Analyzer.

To open SQL Server Query Analyzer

  1. Click Start, point to Programs, point to Microsoft SQL Server and then click Query Analyzer.

  2. In the Connect to SQL Server dialog box, connect to the Direct Mailer database your server is configured to run against.

  3. Type the following query in Query Analyzer window:

    "SELECT * FROM dml_job_errors WHERE job_id = '<job id>' 
    

    where <job id> is the job number you copied from step 5 in the To open Event Viewer procedure.

The returned result set indicates the error code and description for each failure that occurred while the Direct Mailer job was processed.


All rights reserved.