...

• The exit_code will be 0 If the SQL*Plus script terminates successfully.
• If std_err_output is not empty then the exit code will be set to the value 99.
• If either SP2* or ORA-* errors occur then the exit code will be set to the value 98.

Cancellation

The following operations are available:

• The cancel operation is applied to the order, not to the SQLPlusJob. In case of cancellation the job will continue until completion and the order will be put in the failed state.
• The cancel/kill operation is applied to the order and to the job. The SQLPlusJob will be killed and the shell process executing the sqlplus command line utility will be terminated. This includes that the database connection will be closed and the DBMS session will be terminated. The order will be put in the failed state.
  • The DBMS decides about rolling back transactions when closing the client session.

Further Resources

• JS7 - JITL PLSQLJob
• JS7 - JITL SQLExecutorJob
• JS7 - JITL Common ParametersVariables
• JS7 - Job Resources
• JS7 - Use of Credential Store with JITL Jobs

...