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_id C
civicrm_mailing_job.parent_id FK_civicrm_mailing_job_parent_id C
civicrm_mailing_spool.job_id FK_civicrm_mailing_spool_job_id C
mailing_id INT UNSIGNED 10 null FK_civicrm_mailing_job_mailing_id C

The ID of the mailing this Job will send.

scheduled_date DATETIME 19 null

date on which this job was scheduled.

start_date DATETIME 19 null

date on which this job was started.

end_date DATETIME 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 FK_civicrm_mailing_job_parent_id C

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

Table contained 0 rows


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