Cisco Cisco Workload Automation 6.3 User Guide

Contents 3
Preface 5

Audience 5
Related Documentation 5
Obtaining Documentation and Submitting a Service Request 5
Document Change History 5

Introducing the JDBC Adapter 7

Overview 7
Requirements 7

Configuring the JDBC Adapter 9

Overview 9
Licensing an Adapter 9Configuring the JDBC Adapter 10
Securing the JDBC Adapter 13

Defining Runtime Users (Database Users) 14
Authorizing Schedulers to Work With JDBC Jobs and Events 14

Defining a JDBC Security Policy 14
Defining a CWA User of JDBC Jobs and Events 16

Defining a Connection Using JDBC 17

Adding a Connection Using JDBC 18
JDBC Connection Status Light 21

Defining JDBC Jobs 23

Overview 23
Adding a JDBC SQL Job 23
Adding a JDBC Stored Procedure Job 27

Working with JDBC Jobs 31

Overview 31
Understanding JDBC Job Runtime Details 31

Output Tab 31
JDBC Tab 32
Run Info Tab 33

Controlling Adapter and Agent Jobs 34

Holding a Job 34Aborting a Job 34Rerunning a Job 34Making One Time Changes to an Adapter or Agent Job Instance 34Deleting a Job Instance before It Has Run 35

Working with JDBC Events 37

Overview 37
Adding a JDBC Event 37
Assigning an Action to an Event 42

Configuring service.props 45

About Configuring service.props 45
service.props Properties 45

Contents