civicrm_mailing_job

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_mailing_event_queue.job_id FK_civicrm_mailing_event_queue_job_idC
civicrm_mailing_job.parent_id FK_civicrm_mailing_job_parent_idC
civicrm_mailing_spool.job_id FK_civicrm_mailing_spool_job_idC
mailing_id INT UNSIGNED 10 null
civicrm_mailing.id FK_civicrm_mailing_job_mailing_idC

The ID of the mailing this Job will send.
scheduled_date TIMESTAMP 19 √ null

date on which this job was scheduled.
start_date TIMESTAMP 19 √ null

date on which this job was started.
end_date TIMESTAMP 19 √ null

date on which this job ended.
status VARCHAR 12 √ null

The state of this job
is_test TINYINT 3 √ 0

Is this job for a test mail?
job_type VARCHAR 255 √ null

Type of mailling job: null | child
parent_id INT UNSIGNED 10 √ null
civicrm_mailing_job.id FK_civicrm_mailing_job_parent_idC

Parent job id
job_offset INT 10 √ 0

Offset of the child job
job_limit INT 10 √ 0

Queue size limit for each child job

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_mailing_job_mailing_id Performance Asc mailing_id
FK_civicrm_mailing_job_parent_id Performance Asc parent_id

Relationships

Close relationships within degrees of separation