Cisco Cisco Workload Automation 6.3 ユーザーガイド

ページ / 48
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.
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.