rs_dba_scripts
The following table lists the columns for the rs_dba_scripts view. The equivalent jcs_dba_scripts 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 (schema) of a script |
| NAME | VARCHAR2 | The unique name of a script within a schema |
| VERSION | NUMBER | The version number of a script |
| DESCRIPTION | VARCHAR2 | The script description |
| APPLICATION_PARTITION | VARCHAR2 | The partition of the application; can be used to group Redwood objects in logical groups |
| APPLICATION_NAME | VARCHAR2 | The name of the application; can be used to group Redwood objects in logical groups |
| SCRIPT_ID | NUMBER | The unique script id |
| TYPE | NUMBER | Type of script: 1=operating system command, 2=PL/SQL script, 3=chain |
| FORMAT_PARTITION | VARCHAR2 | The format partition of the script output |
| FORMAT_NAME | VARCHAR2 | The format name of the script output |
| QUEUE_PARTITION | VARCHAR2 | The partition of the Queue where the script will be processed |
| QUEUE_NAME | VARCHAR2 | The name of the Queue where the script will be processed |
| TIME_WINDOW_PARTITION | VARCHAR2 | Partition of the Time Window that will be used for the job scheduling |
| TIME_WINDOW_NAME | VARCHAR2 | Name of the Time Window that will be used for the job scheduling |
| SUBMIT_FRAME_PARTITION | VARCHAR2 | Partition of the Submit Frame that will be used for the job scheduling |
| SUBMIT_FRAME_NAME | VARCHAR2 | Name of the Submit Frame that will be used for the job scheduling |
| RESOURCE_PARTITION | VARCHAR2 | The partition of the resource that this script needs; a scheduler provides this |
| RESOURCE_NAME | VARCHAR2 | The name of the resource that this script needs; a scheduler provides this |
| SCRIPTTYPE_PARTITION | VARCHAR2 | The partition of the external script type |
| SCRIPTTYPE_NAME | VARCHAR2 | The name of the external script type |
| OS_USER | VARCHAR2 | The OS user whose credentials should be used when running this script |
| PRIORITY | NUMBER | The predefined job priority |
| MAX_PRIORITY | NUMBER | The predefined maximum job priority |
| RESTART_UNKNOWN | VARCHAR2 | Restart if job status is set to unknown (Y or N)? |
| RESTART_ERROR | VARCHAR2 | Restart if status is error (Y or N)? |
| RESTART_KILLED | VARCHAR2 | Restart if status is killed (Y or N)? |
| RESTART_COMPLETED | VARCHAR2 | Restart if status is completed (Y or N)? |
| RESTART_COUNT | NUMBER | Maximum number of restarts |
| STATUS_ON_SUBMIT | VARCHAR2 | Initial status after submission |
| VERIFY | VARCHAR2 | Password and parameter validation before starting job execution (Y or N) |
| ACCOUNT | VARCHAR2 | Type of account used: script, os or user |
| EXCLUSIVE_EXECUTION | VARCHAR2 | Will this script have the entire system to itself whilst running |
| KEEP_VERSIONS | NUMBER | The number of versions to be kept |
| KEEP_FORCE | VARCHAR2 | Should this keepclause always be considered? |
| KEEP_PER_USER | VARCHAR2 | An indication (Y or N) whether the job output is kept per user |
| KEEP_TYPE | VARCHAR2 | Indicates the type of keep clause, S=System, U=User, K=Key |
| KEEP_UNTIL | VARCHAR2 | The date until which the job output should be stored |
| AVG_CPU_COST | NUMBER | Statistic: the average CPU cost of the jobs run using this script, in seconds |
| AVG_RUN_TIME | NUMBER | Statistic: the average run time of the jobs created by the script in seconds |
| AVG_OUTPUT_FILESIZE | NUMBER | Statistic: the average file size of the output file |
| AVG_LOG_FILESIZE | NUMBER | Statistic: the average file size of the log file |
| STDDEV_CPU_COST | NUMBER | Statistic: standard deviation of the CPU cost in seconds |
| STDDEV_RUN_TIME | NUMBER | Statistic: standard deviation of the run time in seconds |
| STDDEV_OUTPUT_FILESIZE | NUMBER | Statistic: standard deviation of the file size of the output file |
| STDDEV_LOG_FILESIZE | NUMBER | Statistic: standard deviation of the file size of the log file |
| EXECUTION_COUNT | NUMBER | Statistic: the number of jobs executed successfully |
| PARAMETER_COUNT | NUMBER | The number of parameters defined for the script |
| OVERDUE | VARCHAR2 | Set scripts that are not run within their timewindow to OVERDUE? |
| COMMENT_TEXT | VARCHAR2 | Comment describing the script |
| FAILED_EXECUTION_COUNT | NUMBER | Statistic: the number of jobs executed with an error |
| CHILD_SCRIPT_ONLY | VARCHAR2 | Is the script usable as a child job only (Y or N)? |
| NOCOMPILE | VARCHAR2 | Is EOB generation skipped (Y or N)? |
| INVALID | VARCHAR2 | Is the script valid (Y or N)? |
| USE_DIRECTORY | VARCHAR2 | Are jobs for this script bound to a specific directory |
| USE_CONTEXT_DEFAULTS | VARCHAR2 | Are job parameters filled with context dependent defaults? |
| LIGHTWEIGHT | VARCHAR2 | Can this script be used for lightweight jobs? |
| OPTIONAL_TW | VARCHAR2 | Is the Time Window for this script optional |
| OPTIONAL_SF | VARCHAR2 | Is the Submit Frame for this script optional |
| KEEP_STATUS | VARCHAR2 | A possible overwrite for the more global keep_status |
| SUBMIT_FRAME_STATUS | VARCHAR2 | A possible overwrite for the more global submit_frame_status |
| EVENT_EXPRESSION | VARCHAR2 | The boolean wait event expression |
| RETURNCODE_MAP_TO_COMPLETED | VARCHAR2 | What return codes map to completed |
| PIN_TO_PARENT_SCHEDULER | VARCHAR2 | Jobs for this script run on the same scheduler as the parent job |
| ALLOW_DESTINATION | VARCHAR2 | Jobs for this script can be sent to a destination |
| NO_FULL_TEXT_SEARCH | VARCHAR2 | Jobs for this script are skipped for FTS (if column is Y) |
| NO_TRIGGERS | VARCHAR2 | Jobs for this script do not use ON_STATUS_CHANGE triggers (if column is Y) |
| NO_STATISTICS | VARCHAR2 | This script does not keep statistics (if column is Y) |
| NO_WAIT | VARCHAR2 | Jobs for this script cannot be waited for (if column is Y) |
Note: VERSION: Version is not increased with one anymore after changing the object.
Note: INVALID: The column invalid always shows N for non OracleJob job definitions and ? for all OracleJob job definitions.