SQL Query to Fetch Active Events and Related Details from Quartz Table

Requirement: User may need to fetch all related details of all the Active Events.
Solution: A SQL query can be used to fetch the details from Quartz table. Following are the list of queries for related details that a user can run:
1. To fetch a list of active events:
>>SELECT JOB_NAME FROM ABPM_JOB_DETAILS;
SELECT TRIGGER_NAME, JOB_NAME FROM ABPM_TRIGGERS;


2. Last fired time of event and related process flows
>>SELECT TRIGGER_NAME, JOB_NAME, PREV_FIRE_TIME FROM ABPM_TRIGGERS ;
We don't provide the related process flow information in the quartz table, but we can get a related process flow info from the event log table by using the following query:-
SELECT AU_MSG FROM AU_EVENTLOG WHERE EVENT_NAME = name of event;

3. Status of last fired event SKIPPED/SUSPENDED/EXECUTED/FAILED etc.
>>We don't provide the status of the last fired event.

4. For the fired event, need the status of related Process flow instance 
>>We don't contain the information of the related process flow

5. Next firing time of the event

>>SELECT 
TRIGGER_NAME, JOB_NAME, NEXT_FIRE_TIME FROM ABPM_TRIGGER;

Have more questions? Submit a request

0 Comments

Article is closed for comments.