Insertion of line failed

[bart12872]

1. If database connection fails due to some reason and the rows cannot be inserted in TB_01

The job gets aborted. You have to catch the status of the job.
And think about a restartable sequencer

2. If the table gets locked and the rows cannot be inserted in TB_01

Same thing, think about restartable sequence.


imo, your thinking musn't be at line level (line inserted or not) but at job level (job finished or not)
If you doesn't want lock, execute a script before the job to stop request that may cause locks on the table.