Purpose
The DBA_SCHEDULER_PROGRAM view displays all scheduler programs in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | YES | The owner of the scheduler program. |
| PROGRAM_NAME | VARCHAR2(30) | NO | The name of the scheduler program. |
| PROGRAM_TYPE | VARCHAR2(16) | YES | The type of the program action. Valid values: PLSQL_BLOCKSTORED_PROCEDUREEXECUTABLE |
| PROGRAM_ACTION | VARCHAR2(4000) | YES | The string that specifies the program action. |
| NUMBER_OF_ARGUMENTS | NUMBER(38) | YES | The number of arguments accepted by the program. |