Cisco Cisco Workload Automation 6.3 ユーザーガイド
39
Working with JDBC Events
Adding a JDBC Event
If selected, the
Custom Query
field displays as shown below.
7.
If there is no database displayed in the
Database Name
field, select one from the drop-down menu.
If the database was entered on the
Connection Definition
dialog, it appears here on the
JDBC Monitor
tab as
read-only in the
Database Name
field.
8.
From the
Table Name
list, select the name of the data table to be monitored.
9.
If the
Column Name
field is displayed, select a column from the drop-down menu.
10.
If the
Custom Query
field is displayed, enter a query.
A custom event triggers when a nonempty result set is returned from a custom query.
11.
From the
Threshold
drop-down menu, select a threshold for the selected event.
—
For the
Row count exceeds threshold
event,
once the threshold is exceeded and the event is triggered, it
will trigger again only if the row count drops below the threshold and then goes above the threshold again.
—
For the MIN event, if the smallest monitored column value falls below the threshold, the event will trigger. The
event will only trigger again if the column minimum value goes above the threshold and drops below it again.
event will only trigger again if the column minimum value goes above the threshold and drops below it again.
—
For the MAX event, if the largest monitored column value goes above the threshold, the event will trigger. The
event will only trigger again if the column maximum value drops below the threshold and goes above it again.
event will only trigger again if the column maximum value drops below the threshold and goes above it again.