qrtz_cron_triggers


Description

{“what”:“Holds cron-specific parameters for triggers that use cron scheduling.”,“why”:“Without it, cron triggers would lack their schedule definition and timezone.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.779580452+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sched_name varchar 120 null
qrtz_triggers.sched_name fk_qrtz_cron_triggers_triggers R

{“what”:“Scheduler instance name that owns this trigger; part of composite key.”,“why”:“Distinguishes triggers across multiple scheduler instances in a shared database.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.799759224+00:00”}

trigger_name varchar 200 null
qrtz_triggers.trigger_name fk_qrtz_cron_triggers_triggers R

{“what”:“Unique name of the trigger within its group and scheduler.”,“why”:“Identifies the specific trigger for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.868476036+00:00”}

trigger_group varchar 200 null
qrtz_triggers.trigger_group fk_qrtz_cron_triggers_triggers R

{“what”:“Group name that organizes triggers; part of composite key.”,“why”:“Allows grouping triggers for batch operations and avoids name collisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.903964898+00:00”}

cron_expression varchar 120 null

{“what”:“Cron syntax string defining the firing schedule (e.g., "0 0 12 * * ?").”,“why”:“Without it, the trigger has no schedule and cannot fire.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.934930710+00:00”}

time_zone_id varchar 80 √ null

{“what”:“IANA time zone identifier used to interpret the cron expression.”,“why”:“Ensures schedule aligns with a specific timezone; missing it may default to server timezone causing unexpected firing times.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.956317443+00:00”}

Indexes

Constraint Name Type Sort Column(s)
pk_qrtz_cron_triggers Primary key Asc/Asc/Asc sched_name + trigger_name + trigger_group

Relationships