Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| sched_name | varchar | 120 | null |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |