Cisco Cisco Workload Automation 6.3 사용자 가이드

Working with JDBC Events

Assigning an Action to an Event

In the 

field, click the down arrow to enter a time in the clock dialog or type the time directly 

in the field.

In the 

 field, click the down arrow to enter a time in the clock dialog or type the time directly 

in the field.

To delete a selected time window, click 

.

To delete all of the defined time windows listed in this text field, click 

.

Click 

 to add the new event.

Assigning an Action to an Event

You can assign one or more actions to an event so that you know when the event has triggered or configured an 
automated response. You can add any action for a JDBC event that is available in CWA.

In the 

 pane, select 

.

Click the 

 button on the CWA toolbar or right-click the action on the 

 pane and select 

 

 from 

the context menu to display the 

 dialog.

Figure 1

Action Definition Dialog 

The JDBC event variables that are available with the JDBC adapter are described as follows and only apply when 
the action is associated with a JDBC event:

– Name of database where the event was triggered.

 – The table

 or index

 that triggered the event.

 – The database user who triggered the event.

 – The number of rows in the table that triggered the event. Applies to all events. 

For the custom monitor, the row count is the number of rows in the result set from the custom query.

 – The MAX column value and the MIN column value respectively.

For the custom query monitor, the column value is the value of the first row's first column from the result set.

 – The output of the event selected.