Note
For V4.4.2, this view is available starting with V4.4.2 BP1.
For V4.6.x, this view is available starting with V4.6.1.
Overview
Displays all jobs running under the tenant.
Columns
Field Name |
Field type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| OWNER | varchar(128) | NO | Job Owner |
| JOB_NAME | varchar(128) | NO | Job Name |
| JOB_SUBNAME | varchar(128) | NO | This field is not supported in the current version. |
| JOB_STYLE | varchar(17) | YES | Unified asREGULAR |
| DETACHED | varchar(5) | NO | This field is not supported in the current version. |
| SESSION_ID | decimal(10,0) | YES | Session ID |
| SLAVE_PROCESS_ID | decimal(10,0) | NO | This field is not supported in the current version. |
| SLAVE_OS_PROCESS_ID | decimal(10,0) | NO | This field is not supported in the current version. |
| RUNNING_INSTANCE | decimal(10,0) | NO | This field is not supported in the current version. |
| RESOURCE_CONSUMER_GROUP | varchar(128) | NO | This field is not supported in the current version. |
| ELAPSED_TIME | decimal(10,0) | NO | Running Time |
| CPU_USED | decimal(10,0) | 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) | YES | 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) | YES | This field is not supported in the current version. |
| THIS_DATE | datetime(6) | YES | The time when the job starts execution this time (calculated from the start of RPC sending). |
| THIS_EXEC_DATE | datetime(6) | YES | The time when the job starts execution this time (calculated from the moment the executor creates a session). |
| THIS_EXEC_ADDR | varchar(128) | YES | SVR IP Address for This Job Execution |
| THIS_EXEC_TRACE_ID | varchar(128) | YES | The trace ID of the job execution |
Sample query
Run the following command to query all running jobs in the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_SCHEDULER_RUNNING_JOBS\G
The query result is as follows:
TENANT_ID:1
OWNER:root@%
JOB_NAME:201001.e_eventbody_privilege_hrh
JOB_SUBNAME:NULL
JOB_STYLE:REGULAR
DETACHED:NULL
SESSION_ID:
3221532050
SLAVE_PROCESS_ID:
NULL
SLAVE_OS_PROCESS_ID:
NULL
RUNNING_INSTANCE:NULL
RESOURCE_CONSUMER_GROUP:NULL
ELAPSED_TIME:2
CPU_USED:
NULL
DESTINATION_OWNER:NULL
DESTINATION:
NULL
CREDENTIAL_OWNER:
NULL
CREDENTIAL_NAME:NULL
THIS_DATE:2026-02-09 14:51:40.023010
THIS_EXEC_DATE:2026-02-09 14:51:40.046197
THIS_EXEC_ADDR:
:6.12.233.95:10202
THIS_EXEC_TRACE_ID:Y27DA060CE95F-00064A5E79750AB6-0-0
**************************2.rOW***************************
TENANT_ID:1002
OWNER:SYS
JOB_NAME:test_job
JOB_SUBNAME:
NULL
JOB_STYLE:REGULAR
DETACHED:
NULL
SESSION_ID:
3221532045
SLAVE_PROCESS_ID:
NULL
SLAVE_OS_PROCESS_ID:
NULL
RUNNING_INSTANCE:
NULL
RESOURCE_CONSUMER_GROUP:NULL
ELAPSED_TIME:2
CPU_USED:
NULL
DESTINATION_OWNER:NULL
DESTINATION:NULL
CREDENTIAL_OWNER:NULL
CREDENTIAL_NAME:
NULL
THIS_DATE:
2026-02-0914:51:40.017257
THIS_EXEC_DATE:
2026-02-0914:51:40.047754
THIS_EXEC_ADDR:6.12.233.95:10202
THIS_EXEC_TRACE_ID:Y27DA060CE95F-00064A5E81A50AB5-0-0
***************************3.**W***************************
TENANT_ID:1004
OWNER:root@%
J0B_NAME:201001.e_eventbody_privilege_hrh
JOB_SUBNAME:
NULL
JOB_STYLE:REGULAR
DETACHED:NULL
SESSI0N_ID:3221532149
SLAVE_PROCESS_ID:
NULL
SLAVE_OS_PROCESS_ID:
NULL
RUNNING_INSTANCE:
NULL
RESOURCE_CONSUMER_GROUP:NULL
ELAPSED_TIME:
1
CPU_USED:NULL
DESTINATION_OWNER:
NULL
DESTINATION:
NULL
CREDENTIAL_OWNER:
NULL
CREDENTIAL_NAME:NULL
THIS_DATE:
:2026-02-0914:51:41.032907
THIS_EXEC_DATE:2026-02-09 14:51:41.059554
THIS_EXEC_ADDR:6.12.233.95:10202
THIS_EXEC_TRACE_ID:Y27DA060CE95F-00064A5E88950A40-0-0
3rowsinset(0.03sec)