Руководство Пользователя для Cisco Cisco Workload Automation 6.3

Скачать
Страница из 48
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.
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 
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.