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.

plsqlTopic

onsiteTopic