qrtz_triggers
and qrtz_fired_triggers
tables do not contain immediate triggers created by org.quartz.Scheduler#triggerJob(org.quartz.JobKey, org.quartz.JobDataMap)
#1277
Unanswered
devurandom
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am running Quartz 2.5.0 with following properties:
I trigger jobs for immediate execution using
org.quartz.Scheduler#triggerJob(org.quartz.JobKey, org.quartz.JobDataMap)
. These jobs take several minutes, so I do have time to inspect the database tables.Based on my observations of periodic triggers and the code of
org.quartz.core.QuartzScheduler#triggerJob(org.quartz.JobKey, org.quartz.JobDataMap)
, I would expect:qrtz_triggers
table withtrigger_name LIKE 'MT_%'
(cf.org.quartz.core.QuartzScheduler#newTriggerId
) and withjob_name
being the name of the job I am trying to execute.qrtz_fired_triggers
to contain a row with thetrigger_name
andjob_name
I saw inqrtz_triggers
, andqrtz_fired_triggers.state = 'ACQUIRED'
, and the row in the other table to change toqrtz_triggers.state = 'ACQUIRED'
.qrtz_triggers.state = 'BLOCKED'
andqrtz_fired_triggers.state = 'EXECUTING'
.However, neither
qrtz_triggers
norqrtz_fired_triggers
appear to contain any hint of the job scheduled for immediate execution. Why is this?If this is not a problem with my configuration, how can I achieve such "trace" of executing jobs?
Beta Was this translation helpful? Give feedback.
All reactions