Database Software

We want to integrate OWB with CA Unicenter AutoSys JM as described in the oracle document (see link below)

http://www.oracle.com/technology/products/warehouse/pdf/OWB_AutoSys%20with%20updates%20mv.pdf


Our current setup is as follows:

We have created a bunch of mappings which we run manually daily using the run_task procedure.

RUN_TASK
( location IN VARCHAR2,
task_type IN VARCHAR2,
task_name IN VARCHAR2,
custom_params IN VARCHAR2 DEFAULT NULL,
system_params IN VARCHAR2 DEFAULT NULL,
oem_friendly IN NUMBER DEFAULT 0,
background IN NUMBER DEFAULT 0
)
RETURN NUMBER;

We intend to create process flows in OWB and then deploy them direct to CA Unicenter AutoSys JM.

Apparently, there is an AutoSys adapter for OWB see link:
http://supportconnectw.ca.com/public/enews/jobmgt/job042104.asp

but I cannot find any information about this anywhere.

Has anyone succesfully been able to schedule OWB jobs through Autosys?... and if so can you give a step by step guide on how this was achieved?

Thanks,

Olu

Edited by: oluakins on 15-Oct-2008 07:43