Cisco Cisco Workload Automation 6.3 User Guide

Working with JDBC Events

Adding a JDBC Event

The

 tab designates the data table

and indexes

 in the JDBC database to be monitored and defines 

the condition that will be considered an event. Once the designated change to the data table is detected, the event 
can be linked to an action to trigger an automatic response to the change. This same tab is displayed in the 

 dialog for the defined event except the options are read-only to provide information about the event that 

occurred. 

On the 

tab, you can do the following:

Specify which database connection to monitor from the list of defined connections from the DB Connection list

Define the condition that will raise the event

In the 

 field, enter a name for the event.

From the 

 list, select the owner of the event.

From the 

 list, specify which database connection to monitor from the list of defined connections. 

From the 

 list, select one of the following to designate as the event trigger: 

Row count exceeds threshold

Column MAX value exceeds threshold

If selected, a 

field displays and is described in Step 9.

Column MIN value below threshold

If selected, a 

field displays as shown above.

Custom query returns results