Oracle 视图 DBA_JOBS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_JOBS是一个系统定义的视图，它列举了系统中的所有作业列表，其中包括定义的和当前执行的作业，以及那些开启了自动执行的作业。用户可以用它来查询作业的详细信息，例如作业的状态、作业的开始和结束时间、运行时间以及作业正在运行的计算机。
要使用DBA_JOBS，可以使用选择语句SELECT * FROM dba_jobs 以显示所有系统中定义的作业；使用条件SELECT * FROM dba_jobs WHERE status=’RUNNING’ 则可以显示正在运行的作业；用户也可以根据需要来编写查询，以查找特定作业的详细信息。
官方英文解释
DBA_JOBS describes all jobs in the database.
Related View
USER_JOBS describes the jobs owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Identifier of job. Neither import/export nor repeated executions change this value. |
|
|
| Login user when the job was submitted |
|
|
| User whose default privileges apply to this job |
|
|
| Default schema used to parse the job For example, if the |
|
| Date on which this job last successfully executed | |
|
| Same as | |
|
| Date that this job started executing (usually null if not executing) | |
|
| Same as | |
|
|
| Date that this job will next be executed |
|
| Same as | |
|
| Total wall clock time spent by the system on this job (in seconds) when it last executed | |
|
|
| |
|
|
| A date function, evaluated at the start of execution, becomes next |
|
| Number of times the job has started and failed since its last success | |
|
| Body of the anonymous PL/SQL block that the job executes | |
|
| Session parameters describing the NLS environment of the job | |
|
| Other session parameters of the session that created the job. The job is run using these parameters. | |
|
| ID of the instance that can execute or is executing the job. The default is 0. |
See Also:
“USER_JOBS”
编辑：一起学习网
标签：作业,详细信息,定义,视图,系统