DBA_JOBS (USER_JOBS) tell you everything All jobs in the database Columns
___________________________
TOTAL_TIME
Total wallclock time spent by the system on this job, in seconds
BROKEN
If Y, no attempt is being made to run this job. See dbms_jobq.broken(job).
INTERVAL
A date function, evaluated at the start of execution, becomes next NEXT_DATE
FAILURES
How many times has this job started and failed since its last success?
WHAT
Body of the anonymous PL/SQL block that this job executes
MISC_ENV
a versioned raw maintained by the kernel, for other session parameters
THIS_DATE
Date that this job started executing (usually null if not executing)
INSTANCE
Instance number restricted to run the job
NLS_ENV
alter session parameters describing the NLS environment of the job
NEXT_SEC
Same as NEXT_DATE. The job becomes due for execution at this time.
THIS_SEC
Same as THIS_DATE. This is when the last successful execution started.
LAST_SEC
Same as LAST_DATE. This is when the last successful execution started.
LAST_DATE
Date that this job last successfully executed
SCHEMA_USER
select * from bar means select * from schema_user.bar
PRIV_USER
USER whose default privileges apply to this job
LOG_USER
USER who was logged in when the job was submitted
JOB
Identifier of job. Neither import/export nor repeated executions change it.
NEXT_DATE
Date that this job will next be executedDBMS_JOBS should be used to manage the job
___________________________
TOTAL_TIME
Total wallclock time spent by the system on this job, in seconds
BROKEN
If Y, no attempt is being made to run this job. See dbms_jobq.broken(job).
INTERVAL
A date function, evaluated at the start of execution, becomes next NEXT_DATE
FAILURES
How many times has this job started and failed since its last success?
WHAT
Body of the anonymous PL/SQL block that this job executes
MISC_ENV
a versioned raw maintained by the kernel, for other session parameters
THIS_DATE
Date that this job started executing (usually null if not executing)
INSTANCE
Instance number restricted to run the job
NLS_ENV
alter session parameters describing the NLS environment of the job
NEXT_SEC
Same as NEXT_DATE. The job becomes due for execution at this time.
THIS_SEC
Same as THIS_DATE. This is when the last successful execution started.
LAST_SEC
Same as LAST_DATE. This is when the last successful execution started.
LAST_DATE
Date that this job last successfully executed
SCHEMA_USER
select * from bar means select * from schema_user.bar
PRIV_USER
USER whose default privileges apply to this job
LOG_USER
USER who was logged in when the job was submitted
JOB
Identifier of job. Neither import/export nor repeated executions change it.
NEXT_DATE
Date that this job will next be executedDBMS_JOBS should be used to manage the job
解决方案 »
- PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the
- plsql developer 附带的Explain plan window中的cardinality bytes cost具体是什么含义?
- 怎样控制字段的权限
- 急!在oracle中有没有类似于msserver sql2000中的@@identity的东西???
- 如何去除表中的备注
- 初学 ORACLE ,众位高手推存两本书吧!
- 如何更改apps和applsys密码呀?
- 菜鸟求助SQL语句:如何删除这个字段?
- 在包(package)中定义的function应该在系统表中有定义
- 正则检验问题
- 这个insert语句该如何写?
- 数据库的并发问题,100分相送
select * from user_jobs;
字段job就是下面的作业号
2,直接删掉它(注意是当前用户)
SQL> begin
2 dbms_job.remove(:job1);
3 end;
4 /