Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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. |