beautypg.com

Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2479

background image

Brocade Network Advisor SAN + IP User Manual

2407

53-1003155-01

Database tables and fields

I

TABLE 327

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 328

QRTZ_TRIGGERS

Field

Definition

Format

Size

TRIGGER_NAME*

Name of the trigger.

varchar

200

TRIGGER_GROUP*

Name of the trigger group.

varchar

200

JOB_NAME

Name of the job.

varchar

200

JOB_GROUP

Name of the job group.

varchar

200

IS_VOLATILE

Whether the trigger should be persisted in the
JobStore for re-use after program restarts.

boolean

DESCRIPTION

A description for the trigger instance - may be useful
for remembering/displaying the purpose of the
trigger, though the description has no meaning to
Quartz.

varchar

250

NEXT_FIRE_TIME

The next fire time in milliseconds.

bigint

PREV_FIRE_TIME

The previous fired time in milliseconds.

bigint

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.

bigint

END_TIME

The job end time (-1 means infinite).

bigint

CALENDAR_NAME

varchar

200

MISFIRE_INSTR

Instructs the scheduler to execute the misfired job.

smallint

JOB_DATA

Persists the job-related info.

bytea

SCHED_NAME DCMScheduler.

varchar

120

TABLE 329

QUERY_BASED_DEVICE_GROUP

Field

Definition

Format

Size

DEVICE_GROUP_ID

int

QUERY_TEXT

text

GROUP_CRITERIA

Holds the dynamic device group criteria XML value.

text

TABLE 330

QUORUM_CARD_GROUP_MAPPING

Field

Definition

Format

Size

ID*

int