job

41 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
job_parameters.job_id FK_job_id R
name varchar 100 null
display_name varchar 100 null
cron_expression varchar 20 null
create_time timestamp 29,6 null
task_priority int2 5 5
group_name varchar 50 √ null
previous_run_start_time timestamp 29,6 √ null
next_run_time timestamp 29,6 √ null
job_key varchar 500 √ null
initializing_errorlog text 2147483647 √ null
is_active bool 1 true
currently_running bool 1 false
updates_allowed bool 1 true
scheduler_group int2 5 0
is_misfired bool 1 false
node_id int4 10 √ null
is_mismatched_job bool 1 √ true
short_name varchar 8 null

Indexes

Constraint Name Type Sort Column(s)
job_pkey Primary key Asc id
job_short_name_key Must be unique Asc short_name

Relationships

Close relationships within degrees of separation