HP Brocade BladeSystem 4/12, User Manual

Page: 614 / 662

582 DCFM Professional User Manual
53-1001773-01
Database tables and fields
D
TABLE 137 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 numeric 13,0
REPEAT_INTERVAL interval for first and second job numeric 13,0
TIMES_TRIGGERED Number of times the corresponding trigger fired numeric 13,0
TABLE 138
QRTZ_FIRED_TRIGGERS
Field Definition Format size
ENTRY_ID* Fired instance ID. varchar 95
TRIGGER_NAME Name of the trigger. varchar 80
TRIGGER_GROUP Name of the trigger group. varchar 80
IS_VOLATILE Whether the job should not be persisted in the
JobStore for re-use after the program restarts. bit
INSTANCE_NAME Trigger instance name. varchar 80
FIRED_TIME The trigger fired time. numeric 13,0
STATE The fired trigger job state. varchar 16
JOB_NAME Name of the job. varchar 80
JOB_GROUP Name of the job group. varchar 80
IS_STATEFUL Whether the job implements the interface
StatefulJob. bit
REQUESTS_RECOVERY True or false. bit
TABLE 139
QRTZ_JOB_LISTENERS
Field Definition Format Size
JOB_NAME* Name of the job. varchar 80
JOB_GROUP* Name of the job group. varchar 80
JOB_LISTENER* Job listener action class instance. varchar 80
TABLE 140
QRTZ_CRON_TRIGGERS
Field Definition Format Size
TRIGGER_NAME* Name of the trigger. varchar 80
TRIGGER_GROUP* Name of the trigger group. varchar 80
CRON_EXPRESSION The CRON trigger Expression (ex:"0 0 12 * * ?" -
meaning:Fire at 12pm (noon) every day). varchar 80
TIME_ZONE_ID Given "cron" expression resolved with respect to the
TimeZone. varchar 80