qrtz_triggers

{“what”:“Scheduler instance name; part of composite primary key.”,“why”:“Distinguishes triggers across multiple scheduler instances in shared tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:11.221095939+00:00”}

{“what”:“Unique trigger name within its group and scheduler.”,“why”:“Identifies a specific trigger for update, pause, or removal.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:11.260941419+00:00”}

{“what”:“Group name for organizing triggers; part of composite key.”,“why”:“Allows grouping triggers for bulk operations like pausing all in a group.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:11.685639601+00:00”}

{“what”:“Name of the job this trigger fires.”,“why”:“Links trigger to its job definition; without it, firing would have no target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:12.141874912+00:00”}

{“what”:“Group name of the associated job.”,“why”:“Together with job_name uniquely identifies the job to execute.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:13.109646869+00:00”}

{“what”:“Free-text description of the trigger’s purpose.”,“why”:“Provides human-readable context for maintenance and debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:13.540936567+00:00”}

{“what”:“Epoch milliseconds of the next scheduled fire time.”,“why”:“Determines when the scheduler should wake up; missing it breaks scheduling.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.256584549+00:00”}

{“what”:“Epoch milliseconds of the last fire time.”,“why”:“Used to compute misfire and for audit; without it, recovery after restart is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.585959063+00:00”}

{“what”:“Priority for firing when multiple triggers are due; higher wins.”,“why”:“Resolves ordering conflicts when several triggers fire at the same time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.647535605+00:00”}

{“what”:“Current state: WAITING, PAUSED, ACQUIRED, etc.”,“why”:“Determines whether the trigger is eligible for firing; without it, scheduler cannot decide.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.736573634+00:00”}

{“what”:“Type of trigger: SIMPLE, CRON, etc.”,“why”:“Defines how next fire time is computed; wrong type breaks scheduling logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.759056058+00:00”}

{“what”:“Epoch milliseconds when the trigger becomes active.”,“why”:“Prevents firing before the start; without it, early fires are possible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.781507908+00:00”}

{“what”:“Epoch milliseconds after which the trigger stops firing.”,“why”:“Limits trigger lifetime; without it, trigger would fire indefinitely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.836405759+00:00”}

{“what”:“Name of a calendar that excludes certain times.”,“why”:“Applies holiday exclusions; without it, trigger would fire on excluded days.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:14.896001467+00:00”}

{“what”:“Instruction code for handling missed fires (e.g., 1=ignore).”,“why”:“Defines behavior when a fire time is missed; without it, misfire policy is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:15.016598762+00:00”}

{“what”:“Serialized job data map (binary) passed to the job.”,“why”:“Carries job-specific parameters; without it, job loses its configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:15.061434054+00:00”}