| Status | ||||
|---|---|---|---|---|
|
| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Introduction
The JobSchedulerPLSQLJob JobSchedulerSQLPlusJob JITL job provides a standardized and parameterized interface for executing Oracle PL/SQLs statementsSQL*Plus scripts. The JobScheduler offers out of the box capability to execute PL/SQLsSQL scripts, passing parameters to the PL/SQL or SQL*Plus script or collecting and passing on the results of a PL/SQL script execution to next job step as a JobScheduler Order parameter. The JobSchedulerPLSQLJob The JobSchedulerSQLPlusJob can be used to execute existing PL/SQL files just by SQL*Plus scripts by referring them in the command parameter.
A Simple JITL
...
SQLPlus Job Example
The following example shows a basic example of the JobSchedulerPLSQLJobJobSchedulerSQLPlusJob . It executes PL/SQL anonymous code blocks a simple SQL Statment - selecting the current system date and displaying it on stdout as order_date.
...