Note
This view is available starting with V4.4.2 BP1.
Purpose
This view displays all running jobs in the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|
|---|---|---|---|---|
| OWNER | varchar(128) | NO | The owner of the job. | |
| JOB_NAME | varchar(128) | NO | The name of the job. | |
| JOB_SUBNAME | varchar(128) | NO | This column is not supported in the current version. | |
| JOB_STYLE | varchar(17) | YES | The value is always REGULAR. |
|
| DETACHED | varchar(5) | NO | This column is not supported in the current version. | |
| SESSION_ID | decimal(10,0) | YES | The session ID. | |
| SLAVE_PROCESS_ID | decimal(10,0) | NO | This column is not supported in the current version. | |
| SLAVE_OS_PROCESS_ID | decimal(10,0) | NO | This column is not supported in the current version. | |
| RUNNING_INSTANCE | decimal(10,0) | NO | This column is not supported in the current version. | |
| RESOURCE_CONSUMER_GROUP | varchar(128) | NO | This column is not supported in the current version. | |
| ELAPSED_TIME | decimal(10,0) | NO | The running duration. | |
| CPU_USED | decimal(10,0) | NO | This column is not supported in the current version. | |
| DESTINATION_OWNER | varchar(261) | NO | This column is not supported in the current version. | |
| DESTINATION | varchar(261) | YES | This column is not supported in the current version. | |
| CREDENTIAL_OWNER | varchar(128) | NO | This column is not supported in the current version. | |
| CREDENTIAL_NAME | varchar(128) | YES | This column is not supported in the current version. | |
| THIS_DATE | datetime(6) | YES | The start time of the job execution (calculated from the time when the RPC request was sent). | |
| THIS_EXEC_DATE | datetime(6) | YES | The start time of the job execution (calculated from the time when the session was created on the execution end). | |
| THIS_EXEC_ADDR | varchar(128) | YES | The IP address of the server where the job is executed. | |
| 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 a MySQL tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_SCHEDULER_RUNNING_JOBS\G
The query result is as follows:
OWNER:root@%
JOB_NAME:201001.e_eventbody_privilege_hrh
JOB_SUBNAME:NULL
JOB_STYLE:REGULAR
DETACHED:NULL
SESSI0N_ID:3221573055
SLAVE_PROCESS_ID:NULL
SLAVE_OS_PROCESS_ID:NULL
RUNNINGINSTANCE:NULL
RESOURCE_CONSUMER_GROUP:NULL
ELAPSED_TIME:5
CPU_USED:NULL
DESTINATION_OWNER:NULL
DESTINATION:NULL
CREDENTIAL_OWNER:NULL
CREDENTIAL NAME:NULL
THIS_DATE:2026-02-0600:42:35.082633
THIS_EXEC_DATE:2026-02-0600:42:35.115865
THIS_EXECADDR:6.12.233.95:10202
THIS_EXEC_TRACE_ID:Y27DA060CE95F-00064A162E213248-0-0
1rowinset（0.00sec）