dml_jobs Table
The dml_jobs table in the DirectMailer database contains information about direct mail jobs.
The following table describes the columns in the dml_jobs table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
job_id |
uniqueidentifier |
no |
The unique identifier for the direct mail job. This is a primary key. |
job_type |
smallint |
no |
Whether the job is real or a test. |
job_time_started |
datetime |
yes |
The time at which the job started running. |
job_time_finished |
datetime |
yes |
The time at which the job finished running. |
job_cmp_item |
int |
no |
The campaign item ID. |
job_css_prefix |
nvarchar(20) |
no |
The Commerce Server site for which the mail is being sent. |
job_mlist_id |
uniqueidentifier |
yes |
The ID of the mailing list that contains the recipients for this mail. |
job_problems |
int |
no |
The number of errors that occurred when the job was run. |
job_status |
int |
no |
The completion status of the job. |
job_attempt |
int |
no |
The number of the attempt at running the job. For example, if the value is 1, this is the first attempt at running the job. |
job_srvname |
nvarchar(31) |
no |
The name of the server from which the mail was sent. |
job_pcf_path |
nvarchar(260) |
yes |
The path of the direct mailer pipeline component file. |
job_created |
datetime |
yes |
The date when the job was created. |