Feature
DBA_SCHEDULER_JOBS displays the scheduler jobs accessible to the current user.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the scheduler job. |
| JOB_NAME | VARCHAR2(128) | NO | The name of the scheduler job. |
| INSTANCE_ID | NUMBER | YES | The ID of the instance where the job runs. |
| STATE | VARCHAR2(15) | YES | The status of the job. Valid values: DISABLEDRETRY SCHEDULEDSCHEDULEDBLOCKEDRUNNINGCOMPLETEDBROKENFAILEDREMOTERESOURCE_UNAVAILABLESUCCEEDEDCHAIN_STALLED |
| ENABLED | VARCHAR2(5) | YES | Indicates whether the job is enabled. |
| NEXT_RUN_DATE | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The next date for running the job. |
| PROGRAM_NAME | VARCHAR2(4000) | YES | The name of the program associated with the job. |
| LAST_START_DATE | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The last date when the job started running. |