Note
This view is introduced since V5.0.1.
Purpose
Displays the scheduler job information of all tenants.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| OWNER | varchar(128) | NO | The owner of the scheduler job. |
| JOB_NAME | varchar(128) | NO | The name of the scheduler job. |
| JOB_SUBNAME | varchar(128) | NO | This field is not supported in the current version. |
| JOB_STYLE | varchar(17) | YES | The style of the job:
|
| JOB_CREATOR | varchar(128) | NO | This field is not supported in the current version. |
| CLIENT_ID | varchar(65) | NO | This field is not supported in the current version. |
| GLOBAL_UID | varchar(33) | NO | This field is not supported in the current version. |
| PROGRAM_OWNER | text | NO | The owner of the program associated with the job. |
| PROGRAM_NAME | text | YES | The name of the program associated with the job. |
| JOB_TYPE | varchar(16) | YES | The type of job action:
|
| JOB_ACTION | text | YES | The inline job action. |
| NUMBER_OF_ARGUMENTS | bigint(20) | YES | The inline number of job arguments. |
| SCHEDULE_OWNER | text | NO | This field is not supported in the current version. |
| SCHEDULE_NAME | text | NO | This field is not supported in the current version. |
| SCHEDULE_TYPE | varchar(12) | NO | This field is not supported in the current version. |
| START_DATE | datetime(6) | YES | The original planned start date of the job. |
| REPEAT_INTERVAL | text | YES | The inline schedule PL/SQL expression or calendar string. |
| EVENT_QUEUE_OWNER | varchar(128) | NO | This field is not supported in the current version. |
| EVENT_QUEUE_NAME | varchar(128) | NO | This field is not supported in the current version. |
| EVENT_QUEUE_AGENT | varchar(523) | NO | This field is not supported in the current version. |
| EVENT_CONDITION | text | NO | This field is not supported in the current version. |
| EVENT_RULE | varchar(261) | NO | This field is not supported in the current version. |
| FILE_WATCHER_OWNER | varchar(261) | NO | This field is not supported in the current version. |
| FILE_WATCHER_NAME | varchar(261) | NO | This field is not supported in the current version. |
| END_DATE | datetime(6) | YES | The date after which the job will no longer run. |
| JOB_CLASS | varchar(128) | YES | The name of the job class associated with the job. |
| ENABLED | varchar(5) | YES | Indicates whether the job is enabled:
|
| AUTO_DROP | varchar(5) | YES | Indicates whether the job is dropped after completion:
|
| RESTART_ON_RECOVERY | varchar(5) | NO | This field is not supported in the current version. |
| RESTART_ON_FAILURE | varchar(5) | NO | This field is not supported in the current version. |
| STATE | varchar(15) | YES | The state of the job:
|
| JOB_PRIORITY | bigint(20) | NO | This field is not supported in the current version. |
| RUN_COUNT | bigint(20) | YES | The number of times the job has run. |
| MAX_RUNS | bigint(20) | NO | This field is not supported in the current version. |
| FAILURE_COUNT | bigint(20) | YES | The number of times the job has failed to run. |
| MAX_FAILURES | bigint(20) | NO | This field is not supported in the current version. |
| RETRY_COUNT | bigint(20) | YES | The number of times the job has been retried. |
| LAST_START_DATE | datetime(6) | YES | The last date when the job started running. |
| LAST_RUN_DURATION | bigint(20) | YES | The time taken to complete the job during the last run. |
| NEXT_RUN_DATE | datetime(6) | YES | The next date when the job is scheduled to run. |
| SCHEDULE_LIMIT | bigint(20) | NO | This field is not supported in the current version. |
| MAX_RUN_DURATION | bigint(20) | YES | The maximum time allowed for the job to run. |
| LOGGING_LEVEL | varchar(11) | NO | This field is not supported in the current version. |
| STORE_OUTPUT | varchar(5) | NO | This field is not supported in the current version. |
| STOP_ON_WINDOW_CLOSE | varchar(5) | NO | This field is not supported in the current version. |
| INSTANCE_STICKINESS | varchar(5) | NO | This field is not supported in the current version. |
| RAISE_EVENTS | text | NO | This field is not supported in the current version. |
| SYSTEM | varchar(5) | NO | This field is not supported in the current version. |
| JOB_WEIGHT | bigint(20) | NO | This field is not supported in the current version. |
| NLS_ENV | text | YES | The national language environment settings of the job. |
| SOURCE | varchar(128) | NO | This field is not supported in the current version. |
| NUMBER_OF_DESTINATIONS | bigint(20) | NO | This field is not supported in the current version. |
| DESTINATION_OWNER | varchar(261) | NO | This field is not supported in the current version. |
| DESTINATION | varchar(261) | NO | This field is not supported in the current version. |
| CREDENTIAL_OWNER | varchar(128) | NO | This field is not supported in the current version. |
| CREDENTIAL_NAME | varchar(128) | NO | This field is not supported in the current version. |
| INSTANCE_ID | varchar(128) | YES | This field is not supported in the current version. |
| DEFERRED_DROP | varchar(5) | NO | This field is not supported in the current version. |
| ALLOW_RUNS_IN_RESTRICTED_MODE | varchar(5) | NO | This field is not supported in the current version. |
| COMMENTS | text | YES | The comments or description of the job. |
| FLAGS | bigint(20) | NO | The flag bits of the job. |
| RESTARTABLE | varchar(5) | NO | This field is not supported in the current version. |
| CONNECT_CREDENTIAL_OWNER | varchar(128) | NO | This field is not supported in the current version. |
| CONNECT_CREDENTIAL_NAME | varchar(128) | NO | This field is not supported in the current version. |
Query example
View the scheduler job information of all tenants.
obclient [oceanbase]> SELECT TENANT_ID, OWNER, JOB_NAME, ENABLED, NEXT_RUN_DATE, STATE, LAST_START_DATE FROM oceanbase.CDB_SCHEDULER_JOBS LIMIT 5;