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”
