Purpose
DBA_SCHEDULER_PROGRAM displays all scheduler programs in the database.
Fields
| Field | 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: 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. |