USER_SCHEDULER_JOB_ARGS

2025-12-04 07:10:02  Updated

Note

OceanBase Database does not support this view.

Purpose

This view displays the parameters of the current user's scheduled jobs.

Columns

Column Type Nullable Description
JOB_NAME VARCHAR2(30) NO The name of the job to which the parameter belongs.
ARGUMENT_NAME VARCHAR2(30) NO The optional name of the parameter.
ARGUMENT_POSITION NUMBER NO The position of the parameter in the parameter list.
ARGUMENT_TYPE VARCHAR2(61) NO The data type of the parameter.
VALUE VARCHAR2(4000) NO The default value of the parameter, if the parameter is of the string type.
DEFAULT_ANYDATA_VALUE VARCHAR2(128) NO The default value of the parameter, if the parameter is of the ANYDATA type.
OUT_ARGUMENT VARCHAR2(5) NO Reserved.

References

  • DBA_SCHEDULER_JOB_ARGS

  • ALL_SCHEDULER_JOB_ARGS

Contact Us