rs_script_postconditions

on-site-related topic

The following table lists the columns for the rs_script_postconditions view. The equivalent jcs_script_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
SEQUENCE_NUMBER NUMBER The sequence number of this postcondition
STATUS VARCHAR2 The status needed to trigger this postcondition
TYPE VARCHAR2 The type of postcondition
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'