Cisco Cisco Workload Automation 6.3 Guia Do Utilizador

Defining JDBC Jobs

Adding a JDBC SQL Job

Click the 

 tab.

Select the 

job type from the 

 list.

If you did not select a database in the 

 

 dialog, you must select one from the 

 

drop-down menu.

If you did select a database in the 

dialog, it appears here on the 

 tab as read-only 

in the 

 field.

In the 

 tab field, type in one or more SQL statements with multiple statements separated by semicolons to 

execute here.

To include parameters that are replaced at runtime, use unique parameter names of your choice preceded by a 
colon, such as 

:id.

In the 

 drop-down menu, select how the query results are formatted. 

XML 

– Writes the query results in XML format.

 – Displays the values in the most readable format.

– Separates values with commas.

 – Separates values with a user-defined character.

In the 

 field, specify the custom character to use for delimiting the column data from the query results if 

or

is selected for 

.

Select the 

 option to write out the column headers of the results as well.

Select the 

 option to include notices and warnings generated during SQL execution in the output. 

If you are using parameters to be replaced at runtime, click the 

 subtab.