--补充几个相关的试图见下:
SELECT * FROM DBA_SCHEDULER_WINDOWS t ;
SELECT * FROM DBA_SCHEDULER_WINDOW_GROUPS;
SELECT * FROM DBA_SCHEDULER_WINGROUP_MEMBERS;
SELECT * FROM V$RSRC_PLAN;
SELECT JOB_NAME, STATE FROM DBA_SCHEDULER_JOBS;
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;
SELECT * FROM ALL_SCHEDULER_RUNNING_CHAINS ;
--运行日志:
SELECT to_char(log_date, 'DD-MON-YY HH24:MM:SS') TIMESTAMP,
job_name, job_class, operation, status
FROM USER_SCHEDULER_JOB_LOG t
where t.log_date >='04-4月 -12 10.00.00.000000 下午 PRC';
select to_char(log_date, 'DD-MON-YY HH24:MM:SS') TIMESTAMP ,
t.owner,t.job_name,t.job_subname,t.status,t.error#
from dba_scheduler_job_run_details t
where log_date >= '11-4月-12 10.01.42.998766 下午 +08:00';
--数据库自动维护任务的试图:
select * from sys.dba_autotask_client t;
select * from sys.dba_autotask_client_job t;
select * from sys.dba_autotask_client_history t;
select * from sys.dba_autotask_job_history t;
select * from sys.dba_autotask_window_clients t;
select * from sys.dba_autotask_window_history t;
对这个问题的分析,还是粗心大意所导致,在修改时间前多检查几遍是完全可以避免的。不过话有说回来,这个问题不出现上面的知识点也不会熟悉的,不过还是要小心为妙,避免这种低级错误的再次发生。
希望遇到此类问题的朋友探讨指点,谢谢!