USER_SCHEDULER_PROGRAM_ARGS

2025-12-09 07:09:36  Updated

Description

OceanBase Database does not support this view at present.

Feature

USER_SCHEDULER_PROGRAM_ARGS displays the arguments of the schedulers owned by the current user.

  • ALL_SCHEDULER_PROGRAM_ARGS

  • DBA_SCHEDULER_PROGRAM_ARGS

Fields

Field Type Nullable Description
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