...

• 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 set to the failed state.
• The cancel/killforce operation is applied to the order and to the job. The SQLExecutorJob will be killedforcibly terminated, any transactions will be rolled back, the database connection will be closed and the DBMS session will be terminated. The order will be put in set to 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 Variables
• JS7 - Job Resources
• JS7 - Use of Credential Store with JITL Jobs

...