User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1661
53-1003153-01
Database tables and fields
I
TABLE 327 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 328 QRTZ_TRIGGERS
Field Definition Format Size
TRIGGER_NAME* Name of the trigger. varchar 200
TRIGGER_GROUP* Name of the trigger group. varchar 200
JOB_NAME Name of the job. varchar 200
JOB_GROUP Name of the job group. varchar 200
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 250
NEXT_FIRE_TIME The next fire time in milliseconds. bigint
PREV_FIRE_TIME The previous fired time in milliseconds. bigint
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. bigint
END_TIME The job end time (-1 means infinite). bigint
CALENDAR_NAME varchar 200
MISFIRE_INSTR Instructs the scheduler to execute the misfired job. smallint
JOB_DATA Persists the job-related info. bytea
SCHED_NAME DCMScheduler. varchar 120
TABLE 329 QUERY_BASED_DEVICE_GROUP
Field Definition Format Size
DEVICE_GROUP_ID int
QUERY_TEXT text
GROUP_CRITERIA Holds the dynamic device group criteria XML value. text
TABLE 330 QUORUM_CARD_GROUP_MAPPING
Field Definition Format Size
ID* int