...

• Note that it is possible to define more than one instruction with the command argument.
  Such instructions are then carried out in the order in which they are written and must be separated by a semicolon.
  • Some DBMS might require an additional newline character.
  • For example:
    • update MY_TABLE set a='foo' where b='bar'; commit;
• Note that order variables and arguments can be injected to the SQL statement(s) of the command argument using the ${variable} syntax.
• The SQLExecutorJob 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.

Cancellation

The following operations are available:

• The cancel operation is applied to the order, not to the SQLExecutorJob. 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 SQLExecutorJob will be killed, 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 SQLPLUSJob
• JS7 - JITL Common Parameters
• JS7 - Job Resources
• JS7 - Use of Credential Store with JITL Jobs

...