HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 85

Table 130, Qrtz_job_listeners, Qrtz_cron_triggers, Qrtz_jtrigger_listeners, Qrtz_scheduler_state

Page 85 highlights

Database tables and fields E TABLE 129 QRTZ_FIRED_TRIGGERS (Continued) Field Definition IS_STATEFUL REQUESTS_RECOVERY Whether the job implements the interface StatefulJob. True or false. Format boolean boolean TABLE 130 QRTZ_JOB_LISTENERS Field Definition JOB_NAME* JOB_GROUP* JOB_LISTENER* Name of the job. Name of the job group. Job listener action class instance. Format varchar varchar varchar TABLE 131 QRTZ_CRON_TRIGGERS Field Definition Format TRIGGER_NAME* TRIGGER_GROUP* CRON_EXPRESSION TIME_ZONE_ID Name of the trigger. Name of the trigger group. The CRON trigger Expression (ex:"0 0 12 * * ?" meaning:Fire at 12pm (noon) every day). Given "cron" expression resolved with respect to the TimeZone. varchar varchar varchar varchar TABLE 132 QRTZ_BLOB_TRIGGERS Field Definition TRIGGER_NAME* TRIGGER_GROUP* BLOB_DATA Name of the trigger. Name of the trigger group. The Scheduler info. Format varchar varchar bytea TABLE 133 QRTZ_JTRIGGER_LISTENERS Field Definition TRIGGER_NAME* TRIGGER_GROUP* TRIGGER_LISTENER* Name of the trigger. Name of the trigger group. The listener action. Format varchar varchar varchar TABLE 134 QRTZ_SCHEDULER_STATE Field Definition INSTANCE_NAME* LAST_CHECKIN_TIME CHECKIN_INTERVAL RECOVERER Instance of the scheduler. Last fired time in milliseconds. Repeat interval. Misfire instruction. Format varchar numeric numeric varchar size Size 80 80 80 Size 80 80 80 80 Size 80 80 Size 80 80 80 Size 80 13,0 13,0 80 Brocade Network Advisor Documentation Updates 77 53-1002363-02

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271

Brocade Network Advisor Documentation Updates
77
53-1002363-02
Database tables and fields
E
IS_STATEFUL
Whether the job implements the interface
StatefulJob.
boolean
REQUESTS_RECOVERY
True or false.
boolean
TABLE 130
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 131
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 132
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 133
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 134
QRTZ_SCHEDULER_STATE
Field
Definition
Format
Size
INSTANCE_NAME*
Instance of the scheduler.
varchar
80
LAST_CHECKIN_TIME
Last fired time in milliseconds.
numeric
13,0
CHECKIN_INTERVAL
Repeat interval.
numeric
13,0
RECOVERER
Misfire instruction.
varchar
80
TABLE 129
QRTZ_FIRED_TRIGGERS (Continued)
Field
Definition
Format
size