Cisco Cisco Workload Automation 6.3 用户指南

www.cisco.com

Defining JDBC Jobs

Overview

You can start creating and scheduling JDBC jobs once you have completed the following:



Added one or more database users to CWA



Defined your connections using JDBC

You can create a JDBC job using the context menu within the 

 pane. You can also edit, copy, and delete an existing 

JDBC job. If you add a JDBC job to a CWA job group, items common between the job group and the JDBC job are 
inheritable. However, unless the parent group has a JDBC agent assigned to it, you must clear the 

 option and 

choose an appropriate JDBC connection. 

Selecting the 

 option from the CWA 

 pane displays the 

 dialog.

There are two types of JDBC adapter jobs that you can define in CWA:



- Direct inclusion of SQL statements, with or without dynamic parameter replacement.



- Reference to a stored procedure, including dynamic or static parameter replacement.

This chapter describes:





Adding a JDBC SQL Job

From the 

 pane, select 

 to display the 

 pane.