DBA_SCHEDULER_PROGRAM_ARGS

2024-03-05 01:54:26  Updated

Purpose

The DBA_SCHEDULER_PROGRAM_ARGS view displays the arguments of all scheduler programs in the database.

Note

OceanBase Database does not support this view at present.

  • USER_SCHEDULER_PROGRAM_ARGS

  • DBA_SCHEDULER_PROGRAM_ARGS

Columns

Column 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.

    Contact Us