User's Manual

Brocade Network Advisor IP User Manual 1513
53-1003056-01
Database tables and fields
I
CHECKIN_INTERVAL Repeat interval. num (13,0)
RECOVERER Misfire instruction. varchar 80
TABLE 319 QRTZ_SIMPLE_TRIGGERS
Field Definition Format size
TRIGGER_NAME* Name of the trigger varchar 80
TRIGGER_GROUP* name of the trigger group varchar 80
REPEAT_COUNT number of times to repeat num (13,0)
REPEAT_INTERVAL interval for first and second job num (13,0)
TIMES_TRIGGERED Number of times the corresponding trigger fired num (13,0)
TABLE 320 QRTZ_JTRIGGER_LISTENERS
Field Definition Format Size
TRIGGER_NAME* Name of the trigger. varchar 80
TRIGGER_GROUP* Name of the trigger group. varchar 80
TRIGGER_LISTENER* The listener action. varchar 80
TABLE 321 QRTZ_TRIGGERS
Field Definition Format Size
TRIGGER_NAME* Name of the trigger. varchar 80
TRIGGER_GROUP* Name of the trigger group. varchar 80
JOB_NAME Name of the job. varchar 80
JOB_GROUP Name of the job group. varchar 80
IS_VOLATILE Whether the trigger should be persisted in the
JobStore for re-use after program restarts.
boolean
DESCRIPTION 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 120
NEXT_FIRE_TIME The next fire time in milliseconds. num (13,0)
PREV_FIRE_TIME The previous fired time in milliseconds. num (13,0)
TRIGGER_STATE The state of the trigger (viz. Error, wait,etc.) varchar 16
TRIGGER_TYPE The type of the trigger (Simple,cron). varchar 8
START_TIME The job start time. num (13,0)
END_TIME The job end time (-1 means infinite). num (13,0)
CALENDAR_NAME varchar 80
MISFIRE_INSTR Instructs the scheduler to execute the misfired job. smallint
JOB_DATA Persists the job-related info. bytea
TABLE 318 QRTZ_SCHEDULER_STATE (Continued)
Field Definition Format Size