job_queue


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
notes.parent_id Defined in XMLR
name VARCHAR 255 null
deleted BIT 1 0
date_entered DATETIME 26 null
date_modified DATETIME 26 null
scheduler_id CHAR 36 null
schedulers.id Defined in XMLR
execute_time DATETIME 26 null
status VARCHAR 20 null
resolution VARCHAR 20 null
message TEXT 65535 null
target VARCHAR 255 null
data LONGTEXT 2147483647 null
requeue BIT 1 0
retry_count TINYINT 3 null
failure_count TINYINT 3 null
job_delay INT 10 null
client VARCHAR 255 null
percent_complete INT 10 null
job_group VARCHAR 255 null
module VARCHAR 255 null
fallible BIT 1 0
rerun BIT 1 0
interface BIT 1 0
assigned_user_id CHAR 36 null
users.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_group_status Performance Asc/Asc job_group + status
idx_job_queue_assigned_del Performance Asc/Asc assigned_user_id + deleted
idx_resolution_executetime Performance Asc/Asc resolution + execute_time
idx_status_entered Performance Asc/Asc status + date_entered
idx_status_modified Performance Asc/Asc status + date_modified
idx_status_scheduler Performance Asc/Asc status + scheduler_id
idx_status_time Performance Asc/Asc/Asc status + execute_time + date_entered
idx_target_jobgroup Performance Asc/Asc target + job_group

Relationships