Oracle教程 2023-02-24

Oracle 视图 DBA_JOBS_RUNNING 官方解释，作用，如何使用详细说明

Oracle视图 DBA_JOBS_RUNNING 视图允许DBA运行dbms_jobs管理的作业查询，查看每个正在运行的作业的详细信息，包括特定的作业的运行状态，运行结果，以及系统返回的任何错误消息。

您可以使用DBA_JOBS_RUNNING视图查询正在运行的作业的数据，如下所示：

SELECT job,last_date,last_sec,this_date,this_sec,failures,next_date,next_sec,interval
FROM DBA_JOBS_RUNNING
ORDER BY job;

DBA_JOBS_RUNNING lists all jobs that are currently running in the instance.

Column	Datatype	Description
`SID`	`NUMBER`	Identifier of process that is executing the job. See “V$LOCK”.
`JOB`	`NUMBER`	Identifier of job. This job is currently executing.
`FAILURES`	`NUMBER`	Number of times this job started and failed since its last success.
`LAST_DATE`	`DATE`	Date that this job last successfully executed.
`LAST_SEC`	`VARCHAR2(8)`	Same as `LAST_DATE`. This is when the last successful execution started.
`THIS_DATE`	`DATE`	Date that this job started executing.
`THIS_SEC`	`VARCHAR2(8)`	Same as `THIS_DATE`. This is when the last successful execution started.
`INSTANCE`	`NUMBER`	Indicates which instance can execute or is executing the job; the default is `0`.

分享到：