User Manual v12.3.0 Owner's manual

1660 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
TABLE 323 QRTZ_PAUSED_TRIGGER_GRPS
Field Definition Format Size
TRIGGER_GROUP* Name of the trigger group. varchar 200
SCHED_NAME DCMScheduler. varchar 120
TABLE 324 QRTZ_SCHEDULER_STATE
Field Definition Format Size
INSTANCE_NAME* Instance of the scheduler. varchar 200
LAST_CHECKIN_TIME Last fired time in milliseconds. bigint
CHECKIN_INTERVAL Repeat interval. bigint
RECOVERER Misfire instruction. varchar 80
SCHED_NAME DCMScheduler. varchar 120
TABLE 325 QRTZ_SIMPLE_TRIGGERS
Field Definition Format size
TRIGGER_NAME* Name of the trigger varchar 200
TRIGGER_GROUP* name of the trigger group varchar 200
REPEAT_COUNT number of times to repeat bigint
REPEAT_INTERVAL interval for first and second job bigint
TIMES_TRIGGERED Number of times the corresponding trigger fired bigint
SCHED_NAME DCMScheduler. varchar 120
TABLE 326 QRTZ_SIMPROP_TRIGGERS
Field Definition Format size
SCHED_NAME varchar 120
TRIGGER_NAME varchar 200
TRIGGER_GROUP varchar 200
STR_PROP_1 varchar 512
STR_PROP_2 varchar 512
STR_PROP_3 varchar 512
INT_PROP_1 int
INT_PROP_2 int
LONG_PROP_1 bigint
LONG_PROP_2 bigint
DEC_PROP_1 numeric 13,4
DEC_PROP_2 numeric 13,4
BOOL_PROP_1 boolean
BOOL_PROP_2 boolean