Cisco Cisco Tidal Enterprise Adapter for zLinux Hoja De Datos

Simpler Approach to Defining and Running Oracle Database Events – Cisco Workload Automation Adapter

for Oracle Database makes processing events simple. Granular Oracle database events can be captured and

can respond to events, such as table modification, index creation, or database row activity. The complete range

of Workload Automation actions also enables any database event to drive the workflow that transforms business

processes into administrative action—efficiently and automatically. As part of an integrated events management

system, Workload Automation makes it possible to view all runtime database events, which supports the

creation of event-based job dependencies quickly and efficiently.

Users can easily pass variables from Cisco Workload Automation to an Oracle database job. With this

capability, they can automatically initiate an Oracle job based on an external event, such as the arrival of a file

from a trading partner or changes in a table from within another data store.

Workload Automation combined with Cisco Workload Automation Adapter for Oracle Database helps to deliver

maximum job throughput, minimum processing time, and rock-solid reliability for an Oracle-centric workload—

without the need to create cumbersome scripts. This powerful duo accomplishes these objectives by providing a

single integrated enterprise job schedule solution that balances the service requirements of all batch workloads,

whether they were created from within Oracle or exist in support of other applications within the enterprise.

Feature Summary

The following Oracle-specific features make the power of this scheduling solution easily accessible to Oracle

users and enable them to quickly become productive:

•

Oracle database job execution automation, including jobs created within Oracle, Oracle Enterprise

Manager, or Workload Automation

•

A pre-processor step for any Oracle database job that supports passing parameter values, such as

selection criteria, to the job prior to execution

•

The ability to schedule and run both native Oracle jobs and PL/SQL definitions

•

The capacity to monitor, set dependencies, and interact with parent-child processes and to group logs

and output to show parent-child relationships

•

Launching of Oracle jobs based on an external events

•

Oracle job output provided in XML and other formats without the need for additional coding

•

Online access to PL/SQL jobs output without the need to create an intermediary file

•

Job response to Oracle DDL and DML events without coding or database triggers

•

The ability to import Oracle Enterprise manager jobs directly into Workload Automation

•

Support for both Workload Automation and Oracle-defined events

•

Seamless integration and streamlined knowledge transfer through the ability to display familiar Oracle

job names, valid commands, and steps in the Workload Automation interface

•

Print and archive parameters used by pre-existing oracle jobs

•

Robust support of multiple Oracle instances and environments

•

User-defined, filtered, real-time web browser views of past, present, and future Oracle database jobs