rs_script_step_postconditions
The following table lists the columns for the rs_script_step_postconditions view. The equivalent jcs_script_step_postconditions view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| OWNER | VARCHAR2 | The owner of the script |
| SCRIPT_NAME | VARCHAR2 | The name of the script |
| SCRIPT_ID | NUMBER | The id of the script |
| STEP_NAME | VARCHAR2 | The name of the step this postcondition belongs to |
| STEP_ID | NUMBER | The id (sequence number) of the step this postcondition belongs to |
| SEQUENCE_NUMBER | NUMBER | The sequence number of this postcondition |
| STATUS | VARCHAR2 | The status needed to trigger this postcondition |
| RETCODE | VARCHAR2 | The return code needed to trigger this postcondition |
| TYPE | VARCHAR2 | The type of postcondition |
| STEP_TO | VARCHAR2 | Continuation point for postcondition_type GOTO (name) |
| STEPTO_ID | NUMBER | Continuation point for postcondition_type GOTO (id) |
| ERROR | NUMBER | Error to be returned for postcondition_type RAISE |
| MESSAGE | VARCHAR2 | Message to be given for postcondition_type RAISE |
note
TYPE: This column can now have two new values that did not exist in version 7: 'Restart Step Delayed' and 'Restart Failed Jobs'
plsqlTopic
onsiteTopic