Is there any way that autosy can directly connect to oracle and run the oracle package.
For Oracle databases, you can install these CA WA AGENT plug-ins on top of the System Agent base installation.
CA WA Agent for Databases:
The CA WA Agent for Databases lets a user perform the following tasks:
■ Execute SQL queries against a relational database
■ Run stored procedures that are contained in a relational database
■ Monitor a relational database for changes to a table
Note: You can schedule jobs for Oracle, Microsoft SQL Server, IBM DB2, and Sybase databases.
CA WA Agent for Oracle E-Business Suite
The CA WA Agent for Oracle E-Business Suite lets a user perform the following tasks:
■ Execute Oracle Applications (OA) single requests
■ Execute OA request sets
■ Monitor the status of executing OA programs
■ Report on OA program execution status
■ Monitor child processes
Oracle E-Business Suite Jobs
You can define jobs to run Oracle E-Business Suite workload.
Note: To run these jobs, your system requires CA WA Agent for UNIX, Linux, or Windows
and CA WA Agent for Oracle E-Business Suite.
You can define the following Oracle E-Business Suite jobs:
Oracle E-Business Suite Copy Job
Copies an existing single request defined on Oracle Applications and runs it under
Oracle E-Business Suite Request Set
Runs multiple programs in an Oracle Applications application.
Oracle E-Business Suite Single Request
Runs a single program in an Oracle Applications application
Business objects? Oa plugin?
connection to oracle database.
If possible how can it direclty connect to oracle db
See Chapter 8:Database Jobs of the User Guide (https://support.ca.com/cadocs/0/CA%20Workload%20Automation%20AE%20Release%2011%203%206%20-%20Public%20Access-ENU/Bookshe…))
Retrieving data ...