Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1277
53-1002696-01
Database tables and fields
H
TABLE 267 QRTZ_BLOB_TRIGGERS
Field Definition Format Size
TRIGGER_NAME* Name of the trigger. varchar 80
TRIGGER_GROUP* Name of the trigger group. varchar 80
BLOB_DATA The Scheduler info. bytea
TABLE 268 QRTZ_CALENDARS
Field Definition Format Size
CALENDAR_NAME* Name of the Calendar. varchar 80
CALENDAR Calendar object. bytea
TABLE 269 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
TABLE 270 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.
boolean
INSTANCE_NAME Trigger instance name. varchar 80
FIRED_TIME The trigger fired time. num (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.
boolean
REQUESTS_RECOVERY True or false. boolean
TABLE 271 QRTZ_JOB_DETAILS
Field Definition Format Size
JOB_NAME* Name of the job. varchar 80
JOB_GROUP* Name of the job group. varchar 80
DESCRIPTION Description of the job (optional). varchar 120