Cisco Cisco Workload Automation 6.3 Guia Do Utilizador
27
Defining JDBC Jobs
Adding a JDBC Stored Procedure Job
Adding a JDBC Stored Procedure Job
To add a stored procedure job:
1.
From the
Navigator
pane, select
Definitions>Jobs
to display the
Jobs
pane.
2.
Click the
Add
button from the CWA toolbar or right-click in either the
Navigator
or
Jobs
pane and select
Add JDBC
Job
from the context menu to display the
JDBC Job Definition
dialog.
3.
In the
JDBC Job Name
field, enter a name up to 50 characters in length for your job.
The JDBC Job Name is an identifier for CWA only. All of the other job definition information, such as Job Class,
Owner, and Parent Group, is also the same as a standard CWA job and is used in the same way.
Owner, and Parent Group, is also the same as a standard CWA job and is used in the same way.
If you are putting your JDBC job into a group, note that unless the parent group selected has a JDBC agent
connection assigned, you must clear the
connection assigned, you must clear the
Inherited
option on the
Run
tab before you can select a connection using
JDBC.
4.
On the
Run
tab, select an agent or adapter name from the
Agent/Adapter Name
list.
5.
Select a runtime user from the
Runtime User
list.
For information on authorizing a runtime user, see
6.
Click the
JDBC Job
tab, then select the
Stored Procedure
job type from the
Type
list.
7.
If you did not select a database in the
Connection
Definition
dialog, you must select one from the
Database
drop-down menu.
If you did select a database in the
Connection Definition
dialog, it appears here on the
JDBC Job
tab as read-only
in the
Database
field.
8.
From the
Stored Procedure
list, select the procedure to execute when the job is run.
You can use an asterisk (*) to limit the number of stored procedures displayed in the drop-down menu. For example,
if you enter store*, only procedures that begin with store are displayed in the drop-down menu.
if you enter store*, only procedures that begin with store are displayed in the drop-down menu.