Note
OceanBase Database does not support this view at present.
Overview
DBA_SCHEDULER_PROGRAM_ARGS describes the arguments of all Scheduler programs in the database.
Related views
USER_SCHEDULER_PROGRAM_ARGS
DBA_SCHEDULER_PROGRAM_ARGS
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(30) | NO | The owner of the program to which the argument belongs. |
| PROGRAM_NAME | VARCHAR2(30) | NO | The name of the program to which the argument belongs. |
| ARGUMENT_NAME | VARCHAR2(30) | NO | The optional name of the argument. |
| ARGUMENT_POSITION | NUMBER | NO | The position of the argument in the argument list. |
| ARGUMENT_TYPE | VARCHAR2(61) | NO | The data type of the argument. |
| METADATA_ATTRIBUTE | VARCHAR2(19) | NO | The metadata attribute. Valid values: * JOB_NAME * JOB_OWNER * JOB_START * WINDOW_START * WINDOW_END * JOB_SUBNAME * EVENT_MESSAGE * JOB_SCHEDULER_START |
| DEFAULT_VALUE | VARCHAR2(4000) | NO | The default value of the argument if the argument is a string. |
| DEFAULT_ANYDATA_VALUE | VARCHAR2(128) | NO | The default value of the argument if the argument is in AnyData format. |
| OUT_ARGUMENT | VARCHAR2(5) | NO | Reserved for future use. |