State
A step is in one of the following states:
not_started | The chain where the step is located is running, but the step has not yet started |
scheduled | A rule started the step with an AFTER clause and the designated wait time has not yet expired. |
running | The step is running. In case of an event step: the step is started and waits for an event. |
paused | The pause attribute is set to true |
succeeded | The step completed succesfully |
failed | The step completed unsuccessfully |
stopped | The step was stopped with dbms_scheduler.stop_job |
stalled | The step is a nested chain that has stalled |
The value of the state is used to formulate rules.
For succeeded, failed and stopped states, the completed attribute is true - otherwise, its false.