DBA_JOBS

最新推荐文章于 2021-09-04 15:49:22 发布

allway2

最新推荐文章于 2021-09-04 15:49:22 发布

阅读量706

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/allway2/article/details/102641974

本文详细介绍了DBA_JOBS视图，该视图用于描述数据库中的所有作业，包括作业标识符、登录用户、权限用户等关键字段，以及与之相关的USER_JOBS视图，适用于数据库管理员和高级用户。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DBA_JOBS

DBA_JOBS describes all jobs in the database.

Related View

USER_JOBS describes the jobs owned by the current user.

Column	Datatype	NULL	Description
`JOB`	`NUMBER`	`NOT NULL`	Identifier of job. Neither import/export nor repeated executions change this value.
`LOG_USER`	`VARCHAR2(30)`	`NOT NULL`	Login user when the job was submitted
`PRIV_USER`	`VARCHAR2(30)`	`NOT NULL`	User whose default privileges apply to this job
`SCHEMA_USER`	`VARCHAR2(30)`	`NOT NULL`	Default schema used to parse the job For example, if the `SCHEMA_USER` is `SCOTT` and you submit the procedure `HIRE_EMP` as a job, the Oracle Database looks for `SCOTT`.`HIRE_EMP`
`LAST_DATE`	`DATE`		Date on which 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 (usually null if not executing)
`THIS_SEC`	`VARCHAR2(8)`		Same as `THIS_DATE`. This is when the last successful execution started.
`NEXT_DATE`	`DATE`	`NOT NULL`	Date that this job will next be executed
`NEXT_SEC`	`VARCHAR2(8)`		Same as `NEXT_DATE`. This is when the last successful execution started.
`TOTAL_TIME`	`NUMBER`		Total wall clock time spent by the system on this job (in seconds) since the first time this job executed. This value is cumulative.
`BROKEN`	`VARCHAR2(1)`		`Y`: no attempt is made to run this job `N`: an attempt is made to run this job
`INTERVAL`	`VARCHAR2(200)`	`NOT NULL`	A date function, evaluated at the start of execution, becomes next `NEXT_DATE`
`FAILURES`	`NUMBER`		Number of times the job has started and failed since its last success
`WHAT`	`VARCHAR2(4000)`		Body of the anonymous PL/SQL block that the job executes
`NLS_ENV`	`VARCHAR2(4000)`		Session parameters describing the NLS environment of the job
`MISC_ENV`	`RAW(32)`		Other session parameters that apply to this job
`INSTANCE`	`NUMBER`		ID of the instance that can execute or is executing the job. The default is 0.