Share via


dml_jobs Table

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.

See Also

Other Resources

Direct Mail Database Tables