Brocade Communications Systems IP250 Database tables and fields Qrtzschedulerstate, Qrtztriggers

	Database tables and fields		I
TABLE 318 QRTZ_SCHEDULER_STATE (Continued)
Field	Definition	Format	Size
CHECKIN_INTERVAL	Repeat interval.	num	(13,0)
RECOVERER	Misfire instruction.	varchar	80
TABLE 319 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	num	(13,0)
REPEAT_INTERVAL	interval for first and second job	num	(13,0)
TIMES_TRIGGERED	Number of times the corresponding trigger fired	num	(13,0)
TABLE 320 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 321 QRTZ_TRIGGERS
Field	Definition	Format	Size
TRIGGER_NAME*	Name of the trigger.	varchar	80
TRIGGER_GROUP*	Name of the trigger group.	varchar	80
JOB_NAME	Name of the job.	varchar	80
JOB_GROUP	Name of the job group.	varchar	80
IS_VOLATILE	Whether the trigger should be persisted in the	boolean
	JobStore for re-use after program restarts.
DESCRIPTION	A description for the trigger instance - may be useful	varchar	120
	for remembering/displaying the purpose of the
	trigger, though the description has no meaning to
	Quartz.
NEXT_FIRE_TIME	The next fire time in milliseconds.	num	(13,0)
PREV_FIRE_TIME	The previous fired time in milliseconds.	num	(13,0)
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.	num	(13,0)
END_TIME	The job end time (-1 means infinite).	num	(13,0)
CALENDAR_NAME		varchar	80
MISFIRE_INSTR	Instructs the scheduler to execute the misfired job.	smallint
JOB_DATA	Persists the job-related info.	bytea

Brocade Network Advisor IP User Manual	1513
53-1003056-01