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 |
|---|---|---|---|
| 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 the status information of the currently running job named test_job.
obclient> SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS WHERE job_name='test_job'\G
The query result is as follows:
OWNER:SYS
JOB_NAME:test_job
JOB_SUBNAME:NULL
JOB_STYLE:REGULAR
DETACHED:NULL
SESSI0N_ID:3221535814
SLAVE_PROCESS_ID:NULL
SLAVE_OS_PROCESS_ID:NULL
RUNNING_INSTANCE:NULL
RESOURCE_CONSUMER_GROUP:NULL
ELAPSED_TIME:+00000:00:08.84
CPU_USED:NULL
DESTINATION_OWNER:NULL
DESTINATION:NULL
CREDENTIAL_OWNER:NULL
CREDENTIAL_NAME:NULL
THIS_DATE:2026-02-0523:10:24.158297+08:00
THIS_EXEC_DATE:2026-02-0523:10:24.358709+08:00
THIS_EXEC_ADDR:6.12.233.95:10202
THIS_EXEC_TRACE_ID:Y27DA060CE95F-00064A150A562B7C-0-0
1rowinset(0.01sec)