Page History
Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Introduction
The job template SQLPLUSJob provides The SQLPLUSJob JITL Job Template provides a standardized and parameterized interface for executing Oracle® SQL*Plus scripts. The job template offers out-of-the-box capabilities
- to execute an SQL*Plus script,
- to pass arguments to an SQL*Plus script,
- to collect results,
- to pass results as Order Variables to the next job.,
- to use a JS7 - Credential Store
Usage
The following example explains the basic use of the SQLPLUSJob. It executes a simple SQL statement selecting the current system date and writing it to stdout.
...
The com.sos.jitl.jobs.db.oracle.SQLPLUSJob
class accepts the following arguments:
Name | Purpose | Required | Default Value | Example |
---|---|---|---|---|
| Path to the SQL script that should be executed | true |
| |
| Database service name or instance name | true |
| |
| User name for database access | true | scott | |
| Password for database access | true | tiger | |
shell_command | Path to the SQL*Plus command line utility | true | sqlplus | |
| Regular expression to parse output and to set order variables for subsequent jobs | false | ^SETs+(\\s)\\s*ISs(.*)$ | |
command_line_options | SQL*Plus command line options | false | -S -L | |
ignore_ora_messages | Ignore Oracle error messages | false | ||
ignore_sp2_messages | Ignore sp2 error messages | false | ||
include_files | Code blocks that should be included before executing the SQL*Plus script | false | ||
credential_store_file | Location of a credential store file (*.kdbx) | false | ./config/private/jobs.kdbx | |
credential_store_key | Location of a credential store file (*.key) | false | ./config/private/jobs.key |
For use of the credential_store_*
arguments see JS7 - Use of Credential Store with JITL Jobs.
Argument: command_script_file
...