HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 84

E Database tables and fields TABLE 127 QRTZ_TRIGGERS (Continued) Field Definition Format JOB_GROUP IS_VOLATILE DESCRIPTION NEXT_FIRE_TIME PREV_FIRE_TIME TRIGGER_STATE TRIGGER_TYPE START_TIME END_TIME CALENDAR_NAME MISFIRE_INSTR JOB_DATA Name of the job group. varchar Whether the trigger should be persisted in the JobStore for re-use after program restarts. boolean A description for the trigger instance - may be useful for remembering/displaying the purpose of the trigger, though the description has no meaning to Quartz. varchar The next fire time in milliseconds. numeric The previous fired time in milliseconds. numeric The state of the trigger (viz. Error, wait,etc.) varchar The type of the trigger (Simple,cron). varchar The job start time. numeric The job end time (-1 means infinite). numeric varchar Instructs the scheduler to execute the misfired job. smallint Persists the job-related info. bytea TABLE 128 QRTZ_SIMPLE_TRIGGERS Field Definition TRIGGER_NAME* TRIGGER_GROUP* REPEAT_COUNT REPEAT_INTERVAL TIMES_TRIGGERED Name of the trigger name of the trigger group number of times to repeat interval for first and second job Number of times the corresponding trigger fired Format varchar varchar numeric numeric numeric TABLE 129 QRTZ_FIRED_TRIGGERS Field Definition ENTRY_ID* TRIGGER_NAME TRIGGER_GROUP IS_VOLATILE INSTANCE_NAME FIRED_TIME STATE JOB_NAME JOB_GROUP Fired instance ID. Name of the trigger. Name of the trigger group. Whether the job should not be persisted in the JobStore for re-use after the program restarts. Trigger instance name. The trigger fired time. The fired trigger job state. Name of the job. Name of the job group. Format varchar varchar varchar boolean varchar numeric varchar varchar varchar Size 80 120 13,0 13,0 16 8 13,0 13,0 80 size 80 80 13,0 13,0 13,0 size 95 80 80 80 13,0 16 80 80 76 Brocade Network Advisor Documentation Updates 53-1002363-02