qrtz_fired_triggers


Description

{“what”:“Records of triggers that have fired and are being executed.”,“why”:“Tracks running jobs for monitoring, recovery, and concurrency control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.099429140+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sched_name varchar 120 null

{“what”:“Scheduler instance name that fired the trigger; part of composite key.”,“why”:“Distinguishes rows from different schedulers in a shared table.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.598612647+00:00”}

entry_id varchar 95 null

{“what”:“Unique identifier for this firing event within the scheduler.”,“why”:“Uniquely identifies a firing record for updates and deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.645826313+00:00”}

trigger_name varchar 200 null

{“what”:“Name of the trigger that caused this firing.”,“why”:“Identifies which trigger is running; needed for job lookup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.660694942+00:00”}

trigger_group varchar 200 null

{“what”:“Group name of the fired trigger.”,“why”:“Groups triggers for management; used with trigger_name to locate trigger definition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.689721104+00:00”}

instance_name varchar 200 null

{“what”:“Name of the scheduler instance that is executing the trigger.”,“why”:“Tracks which node is handling the job; essential for failover and load balancing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.722419019+00:00”}

fired_time int8 19 null

{“what”:“Epoch milliseconds when the trigger fired.”,“why”:“Used to compute execution duration and detect hung jobs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.761781220+00:00”}

sched_time int8 19 √ null

{“what”:“Epoch milliseconds when the trigger was scheduled to fire.”,“why”:“Shows delay between scheduled and actual fire time; helps monitor scheduling accuracy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.875557343+00:00”}

priority int4 10 null

{“what”:“Priority of the fired trigger; higher value runs first.”,“why”:“Determines execution order when multiple triggers fire simultaneously.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.903458324+00:00”}

state varchar 16 null

{“what”:“Current state of the firing, e.g., ACQUIRED or EXECUTING.”,“why”:“Tracks lifecycle of the firing; needed for recovery and cleanup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.961555155+00:00”}

job_name varchar 200 √ null

{“what”:“Name of the job that the trigger is associated with.”,“why”:“Links firing to job details; used for job recovery and monitoring.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.109492439+00:00”}

job_group varchar 200 √ null

{“what”:“Group name of the associated job.”,“why”:“Identifies job group; used with job_name to locate job definition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.264518838+00:00”}

is_nonconcurrent bool 1 √ null

{“what”:“True if the job disallows concurrent execution.”,“why”:“Prevents overlapping executions; needed to enforce concurrency policy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.374717307+00:00”}

requests_recovery bool 1 √ null

{“what”:“True if the job should be re-executed after a scheduler failure.”,“why”:“Determines if the job must be recovered; critical for durability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:41.965992916+00:00”}

Indexes

Constraint Name Type Sort Column(s)
pk_qrtz_fired_triggers Primary key Asc/Asc sched_name + entry_id
idx_qrtz_ft_inst_job_req_rcvry Performance Asc/Asc/Asc sched_name + instance_name + requests_recovery
idx_qrtz_ft_j_g Performance Asc/Asc/Asc sched_name + job_name + job_group
idx_qrtz_ft_jg Performance Asc/Asc sched_name + job_group
idx_qrtz_ft_t_g Performance Asc/Asc/Asc sched_name + trigger_name + trigger_group
idx_qrtz_ft_tg Performance Asc/Asc sched_name + trigger_group
idx_qrtz_ft_trig_inst_name Performance Asc/Asc sched_name + instance_name

Relationships