Purpose
The DBA_SCHEDULER_JOBS view displays the scheduler jobs accessible to the current user.
Note
This view is introduced since OceanBase Database V3.2.3.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the scheduler job. |
| JOB_NAME | VARCHAR2(128) | NO | The name of the scheduler job. |
| JOB_SUBNAME | VARCHAR2(128) | NO | The subname of the scheduler job. |
| JOB_STYLE | VARCHAR2(17) | YES | The style of the scheduler job. Valid values:
|
| JOB_CREATOR | VARCHAR2(128) | NO | The creator of the scheduler job. |
| CLIENT_ID | VARCHAR2(65) | NO | The client ID of the user that created the job. |
| GLOBAL_UID | VARCHAR2(33) | NO | The global user identifier (UID) of the user that created the job. |
| PROGRAM_OWNER | VARCHAR2(4000) | NO | The owner of the program associated with the job. |
| PROGRAM_NAME | VARCHAR2(4000) | YES | The name of the program associated with the job. |
| JOB_TYPE | VARCHAR2(16) | YES | The type of the job. Valid values:
|
| JOB_ACTION | VARCHAR2(4000) | YES | The inline job action. |
| NUMBER_OF_ARGUMENTS | NUMBER | YES | The inline number of job arguments. |
| SCHEDULE_OWNER | VARCHAR2(4000) | NO | The owner of the schedule used by the job. |
| SCHEDULE_NAME | VARCHAR2(4000) | NO | The name of the schedule used by the job. |
| SCHEDULE_TYPE | VARCHAR2(12) | NO | The type of the schedule used by the job. Valid values:
|
| START_DATE | TIMESTAMP(6) WITH TIME ZONE | YES | The original scheduled start date of the job. |
| REPEAT_INTERVAL | VARCHAR2(4000) | YES | An inline schedule PL/SQL expression or calendar string. |
| EVENT_QUEUE_OWNER | VARCHAR2(128) | NO | The owner of the source queue into which the event is to be raised. |
| EVENT_QUEUE_NAME | VARCHAR2(128) | NO | The name of the source queue into which the event is to be raised. |
| EVENT_QUEUE_AGENT | null | NO | The name of the AQ agent used by the user on the event source queue. |
| EVENT_CONDITION | VARCHAR2(4000) | NO | The rule for subscribing to the event on the source queue. |
| EVENT_RULE | VARCHAR2(261) | NO | The name of the rule used by the coordinator to trigger the event-based job. |
| FILE_WATCHER_OWNER | VARCHAR2(261) | NO | The owner of the file watcher on which this job is based. |
| FILE_WATCHER_NAME | VARCHAR2(261) | NO | The name of the file watcher on which this job is based. |
| END_DATE | TIMESTAMP(6) WITH TIME ZONE | YES | The end date of the job. |
| JOB_CLASS | VARCHAR2(128) | YES | The name of the job class associated with the job. |
| ENABLED | VARCHAR2(5) | YES | Indicates whether the job is enabled. Valid values:
|
| AUTO_DROP | VARCHAR2(5) | YES | Indicates whether the job is deleted after it is completed. Valid values:
|
| RESTART_ON_RECOVERY | VARCHAR2(5) | NO | Indicates whether the job is restarted upon a cluster restart. Valid values:
|
| RESTART_ON_FAILURE | VARCHAR2(5) | NO | Indicates whether the job is restarted upon an execution failure. Valid values
|
| STATE | VARCHAR2(15) | YES | The current state of the job. Valid values: |
| JOB_PRIORITY | NUMBER | NO | The priority of the job relative to other jobs in the same class. |
| RUN_COUNT | NUMBER | YES | The number of times that the job has run. |
| MAX_RUNS | NUMBER | NO | The maximum number of times that the job is scheduled to run. |
| FAILURE_COUNT | NUMBER | YES | The number of times that the job has failed to run. |
| MAX_FAILURES | NUMBER | NO | The number of times that the job is allowed to fail before being marked broken. |
| RETRY_COUNT | NUMBER | YES | The number of retries of the job. |
| LAST_START_DATE | TIMESTAMP(6) WITH TIME ZONE | YES | The last date when the job started running. |
| LAST_RUN_DURATION | INTERVAL DAY (9) TO SECOND (6) | NO | The amount of time that the job took to complete during the last run. |
| NEXT_RUN_DATE | TIMESTAMP(6) WITH TIME ZONE | NO | The next date on which the job is scheduled to run. |
| SCHEDULE_LIMIT | INTERVAL DAY (3) TO SECOND (0) | NO | The time after which a job that has not run yet will be rescheduled. |
| MAX_RUN_DURATION | INTERVAL DAY (3) TO SECOND (0) | NO | The maximum duration that the job is allowed to run. |
| LOGGING_LEVEL | VARCHAR2(11) | NO | The level of logging that will be done pertaining to the job. Valid values:
|
| STORE_OUTPUT | VARCHAR2(5) | NO | Indicates whether the output for the job is stored in the database. Valid values:
|
| STOP_ON_WINDOW_CLOSE | VARCHAR2(5) | NO | Indicates whether the job stops if a window associated with the job is closed. Valid values:
|
| INSTANCE_STICKINESS | VARCHAR2(5) | NO | Indicates whether the job is sticky. Valid values:
|
| RAISE_EVENTS | VARCHAR2(4000) | NO | The list of job events to raise for the job. Valid values:
|
| SYSTEM | VARCHAR2(5) | NO | Indicates whether the job is a system job. Valid values:
|
| JOB_WEIGHT | NUMBER | NO | The weight of the job, which indicates the scheduling priority of the job. |
| NLS_ENV | VARCHAR2(4000) | YES | The National Language Support (NLS) environment of the job. |
| SOURCE | VARCHAR2(128) | NO | The source code or script of the job. |
| NUMBER_OF_DESTINATIONS | NUMBER | NO | The number of destinations associated with this job. |
| DESTINATION_OWNER | VARCHAR2(261) | NO | The owner of the destination object. |
| DESTINATION | VARCHAR2(261) | NO | The destination that this job will run on. |
| CREDENTIAL_OWNER | VARCHAR2(128) | NO | The owner of the credential to be used for an external job. |
| CREDENTIAL_NAME | VARCHAR2(128) | NO | The name of the credential to be used for an external job. |
| INSTANCE_ID | NUMBER | YES | The instance on which the user requests the job to run. |
| DEFERRED_DROP | VARCHAR2(5) | NO | Indicates whether the job is dropped when completed due to user request. |
| ALLOW_RUNS_IN_RESTRICTED_MODE | VARCHAR2(5) | NO | Indicates whether the job is allowed to run in restricted mode. |
| COMMENTS | VARCHAR2(4000) | YES | The comments on the job. |
| FLAGS | NUMBER | NO | The flag bit of the job. |
| RESTARTABLE | VARCHAR2(5) | NO | Indicates whether the job can be restarted. |
| CONNECT_CREDENTIAL_OWNER | VARCHAR2(128) | NO | The owner of the connection credentials. |
| CONNECT_CREDENTIAL_NAME | VARCHAR2(128) | NO | The name of the connection credentials. |
