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;
>>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/
>>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;
Comments
0 comments
Article is closed for comments.