Monitoring Direct Mailer Jobs

  • Article

You can check the status of your Direct Mailer jobs to determine if a job is currently running, has been suspended or terminated, or has completed successfully. You can view the status of your Direct Mailer jobs using the command line interface. You can also check to see if any errors occurred while running your Direct Mailer jobs.

To view Direct Mailer job status using the command line interface

To view Direct Mailer job errors

To view Direct Mailer job status using the command line interface

  • At the command line, typeDmlRun /list****to view all Direct Mailer jobs.

The list of Direct Mailer jobs is displayed.

The following information is displayed for each Direct Mailer job:

  • Job identification number
  • Job status
  • Job description
  • Site name
  • Campaign item identification number
  • Campaign item name

Ee785009.note(en-US,CS.20).gif Note

  • Site name, campaign item identification number, and campaign item name are only displayed if they exist for the Direct Mailer job.

The following table lists job status codes.

Code Description
0 The job was created but not initialized.
1 The job was completely defined but not running (Inactive) or the job was terminated.
2 The job completed.
3 The job is running (Active).
4 The job is running but currently suspended (paused, but still Active).
-2 The job was stopped by Direct Mailer due to serious problems or because the error threshold limit was reached.
-3 The job was defined as css_site, but not all the data was available at run time.

To view Direct Mailer job errors

  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
  2. In SQL Server Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, and then expand the name of the database server containing the Direct Mailer database.
  3. Expand Direct Mailer, select Tables, right click dml_job_errors, point to OpenTable, and then select Return all rows.

The Direct Mailer job errors are listed in the table.

Copyright © 2005 Microsoft Corporation.
All rights reserved.