Terracotta Discussion Forums

hi,
qrtz 1.8 Is there a way to get a snapshot of QRTZ_FIRED_TRIGGERS table?

What I am looking for in particular is a way to get ALL trigger info with their respective fired time (and states too if possible).

Thanks.

I dont think you can. That table is internal to quartz.

Plugin, Job and trigger listeners should satisfy most use cases. What are you trying to do?

light5 wrote:

I dont think you can. That table is internal to quartz.

Plugin, Job and trigger listeners should satisfy most use cases. What are you trying to do?

I need to know the unique identifiers of tyhe running triggers and their respective start times

Then use the TriggerListener.

light5 wrote:

Then use the TriggerListener.

It won't help me.
What I am doing is trying to implement expirable triggers. For example if a job is stuck in some I/O operation for more then 30 min. I want to delete its trigger (because it doesn't seem possible to kill the thread itself).

With listener I would need to maintain a local copy like a map of triggers and their start times. I don't see a reason to do it if its all in the DB anyways.

I need to know the unique identifiers of tyhe running triggers and their respective start times

Well, TriggerListener answers what you asked as that.

What I am doing is trying to implement expirable triggers. For example if a job is stuck in some I/O operation for more then 30 min. I want to delete its trigger (because it doesn't seem possible to kill the thread itself).

Well, this is not what your topic is asked about, and TriggerListener might not help here.

If you system is free to create any thread you want, you can something like this in your Job implementation:
Code:

 public void execution(JobExecutionContext ctx) {
     final MyIoWork work = new MyIoWork();
     Thread t = new Thread(new Runnable() {
       public void run() {
         work.start();
       }
     }
 
     t.start();
     while (!work.isDone() && System.currentTimeMllis() < MAX_TIMEOUT)
       Thread.sleep(500);
     if (!work.isDone())
       t.interrupt();
 }

This would work only if your MyIoWork.start() implementation would able to exit your IO block code when running thread is interrupted. But at least you are not prevent by any Quartz related issues. It would become only a general Java and IO blocking issue to solve.

If you your system that running Quartz won't allow you to create Thread freely, then try looking into InterruptableJob as well. You can interrupt your Job at any time by calling org.quartz.Scheduler.interrupt(jobKey), instead of fixed timeout period as above. Again, you must write your Job/Work code to allow to be interrupted in order for the Job to exit.

That's the problem. I need to know WHEN to interrupt

That's the problem. I need to know WHEN to interrupt

You interrupt when it exceed your timeout period, which you said 30 mins for example above.

Yes but how do I know when the jobs started (trigger fired). That is the whole question

The trigger starts as you configured it to be. If you use cron trigger with "0 0 0 * * ?", then it starts at midnight.

Also, your Job.execution(JobExecutionContext ctx) starts when the trigger is fired, so do a time stamp with first statement as "long startTime = System.currentTimeMillis();", that's the time it start.

but again. Were do I keep the info?
after 30 minutes and maybe after the restart of the jvm I want to be able to get the info from the fired_triggers table