Page History
...
- to invoke the Wizard that is available from the job properties tab in the Configuration view and to select the JITL SQLPlusJob SQLPLUSJob and respective arguments from the Wizard
...
The following example shows basic use of the SQLPlusJob SQLPLUSJob. It executes SQL*Plus code from an .sql file and writes output to the stdout channel.
The job arguments can be specified as follows:
...
Documentation
Job Documentation including the full list of arguments: https://www.sos-berlin.com/doc/JS7-JITL/SQLPlusJob.xml
The SQLPlusJob 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 database (*.kdbx) | false | ./config/private/jobs.kdbx | |
credential_store_key | Location of a credential store key file (*.key) | false | ./config/private/jobs.key |
The SQLPLUSJob can be used with a credential store to hold sensitive arguments. For use of the credential_store_*
arguments see JS7 - Use of Credential Store with JITL Jobs.
...
As a result an Order Variable with the name my_variable
and the value some_value
is created. This pattern can be applied to any number of lines each creating a new Order Variable order variable for subsequent instructions and jobs.
...
The std_out_output
variable holds the messages spooled to the stdout channel by SQL*Plus.
Return Variable: std_err_output
The std_err_output
variable contains the messages spooled to the stderr channel by SQL*Plus.
Return Variable: exit_code
...
- JS7 - JITL PLSQLJob
- JS7 - JITL SQLExecutorJob
- JS7 - Job Resources
- JS7 - Use of Credential Store with JITL Jobs