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
Uh oh!
There was an error while loading. Please reload this page.
-
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