job

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
job_parameters.job_id FK_job_idR
job_run_history.job_id scheduledjobsFKR
name VARCHAR 100 null
display_name VARCHAR 100 null
cron_expression VARCHAR 20 null
create_time DATETIME 19 null
task_priority SMALLINT 5 5
group_name VARCHAR 50 √ NULL
previous_run_start_time DATETIME 19 √ NULL
next_run_time DATETIME 19 √ NULL
job_key VARCHAR 500 √ NULL
initializing_errorlog TEXT 65535 √ NULL
is_active BIT 1 b'1'
currently_running BIT 1 b'0'
updates_allowed BIT 1 b'1'
scheduler_group SMALLINT 5 0
is_misfired BIT 1 b'0'
node_id INT 10 √ NULL
is_mismatched_job BIT 1 √ b'1'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation