DCFM Professional Plus User Manual (53-1001774-01, June 2010)

744 DCFM Professional Plus User Manual
53-1001774-01
Sybase and Derby Database Fields
D
TABLE 170 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 171 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 172 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 173 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