| Panel | |
|---|---|
|
Disclaimer
Your use of this download is governed by Stonebranch’s Terms of Use, which are available at Stonebranch Integration Hub - Terms of Use.
Overview
Oracle Scheduler, a feature embedded in Oracle Database, facilitates the automation of a variety of tasks, jobs, and processes within the database environment. Users can schedule and oversee the execution of jobs, programs, and scripts at specified intervals or in response to events. The This Universal Task in Stonebranch enables users to directly schedule, trigger, monitor, and orchestrate jobs and job chains within the Oracle Scheduler through the Python module cx_Oracle in Universal Controller. Additionally, it allows the establishment of dependencies among different Oracle jobs or job chains, as well as connections with processes in other applications or platforms through UAC workflows. This integration permits Oracle Scheduler jobs to be triggered from UAC, either through time-based or event-based mechanisms.
Version Information
| Template Name | Version |
|---|---|
| CS Oracle Scheduler | 1.0.0 |
...
- Universal Agent for Windows x64 Version 7.1.0.0 and later with Python options installed.
- Universal Agent for Linux Version 7.1.0.0 and later with Python options installed.
- Ensure Python Module: cx_Oracle is installed in the agent host and accessible to the UAC execution User.
- It should be also ensured that Oracle client libraries are installed in agent install host
Software Requirements for Universal Controller
...
Network and Connectivity Requirements
Oracle Client Library and the python module cx_Oracle is installed in the agent host and configured to connect to the Oracle Database Server.
Key Features
This Universal Task provides the following features:
...
| Field | Input type | Default value | Type | Description |
|---|---|---|---|---|
| Select a Function | Required | - | Choice | Select the required function
|
| Database Name | Required | - | Text | Database name or Oracle service name |
| Server | Required | - | Text | Oracle server name or the IP address |
| Oracle Credentials | Required | - | Text | The Oracle database user credentials for job execution, The Credentials definition should be as follows.
|
| Port | Required | - | Text | Port of the Database Example: 1521 |
| Connection Mode | Required | - | Choice | Connection Authorization Mode: [sysdba | sysasm | sysoper | sysbkp | sysdgd | syskmt | None] |
| Oracle Job Name | Required | - | Text | Specify the Oracle scheduler Job Name (For chains as well specify the Job Name) the same should be used in Plsql job/chain |
| PLSQL Job/Chain execution script | Required | - | Script | Oracle scheduler job execution script & run-time parameters, Job name should be SAME as in Oracle Job name |
| Job Status check - Poll Interval (seconds) | Required | 10 | Integer | Oracle Job execution Monitor Interval, Default is 10 Seconds |
| Max Number of Times to Poll | Required | 50 | Integer | Specify the Maximum number of times to poll, Default is 50 times |
| Log Level | Required | Info | Choice | Universal Task logging settings [DEBUG | INFO| WARNING | ERROR | CRITICAL] |
...
| Exit Code | Status Classification Code | Status Classification Description | Status Description |
|---|---|---|---|
| 0 | SUCCESS | Successful Execution | Success: Successful Task execution |
| 1 | FAILED | Failed Execution | Failed: Oracle job execution Failed |
| 10 | SUCCESS or Failed | Success or Failed execution | Success or Failure : Terminating the Oracle job execution monitor as it has exceeded the maximum polling time |
STDOUT and STDERR
STDOUT and STDERR provide additional information to the User. The populated content can be changed in future versions of this extension without notice. Backward compatibility is not guaranteed.
...