2

From my understanding, all triggers in QRTZ_SIMPLE_TRIGGERS will be added to QRTZ_FIRED_TRIGGERS after it has been fired. However, I found there still nothing inside QRTZ_FIRED_TRIGGERS even those triggers in QRTZ_SIMPLE_TRIGGERS existing and being deleted?

May I know when will the trigger be moved to QRTZ_FIRED_TRIGGERS?

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67
mannok
  • 1,712
  • 1
  • 20
  • 30

1 Answers1

0

[Not accurate, perspective result]

From my perspective (from clicking refresh until a trigger has been inserted into fired_triggers table and right before triggering and being deleted)

trigger data gets inserted into fired_triggers table right about 20seconds before being triggered [need more proof research] and finally gets deleted after trigger has finished.

and also QRTZ_SIMPLE_TRIGGERS having no data is due to creating a job with .durable() settings to false. Since this setting makes a specific job dependant to triggers.

Sorry for my bad english. Hope this helped a little.

Jason
  • 1
  • 1