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'