Batch Status

When a run is started, all directories and sheets are resolved to their contained transformations, and these transformations are inserted into the transformation queue (sqts_action_queue) in status "D" for Dependency Wait. For the run, the higher element levels (sheet/directory) are no longer relevant.

During the run, transformations in a batch are set to status "Waiting" when they have no source that has not yet been successfully executed. If a transformation does not depend on any transformation within this batch, it is also set to status "Waiting".

When creating a run, dependencies are determined once and stored in the sqts_batch_instance_dependency table.

A run can be manually halted and restarted. There is only one final status "Finished" which cannot be restarted. When halting a run, the status is set to interrupted, and after the last active task has finished, the run is set to status halted.

State Diagram Run