Oracle从10g开始对job进行了扩展,以前的job能够完成的任务,建议利用scheduler job进行完成。
1,常见的scheduler job维护视图
1,常见的scheduler job维护视图
--DBA调度任务dba_scheduler_jobs
select OWNER,JOB_NAME,to_char(START_DATE,'yyyy-mm-dd hh24:mi:ss') START_DATE,to_char(LAST_START_DATE,'yyyy-mm-dd hh24:mi:ssi') LAST_START_DATE,ENABLED,STATE from DBA_SCHEDULER_JOBS;
select OWNER,SYSTEM,JOB_NAME,JOB_TYPE,to_char(START_DATE,'yyyy-mm-dd hh24:mi:ss') START_DATE,to_char(LAST_START_DATE,'yyyy-mm-dd hh24:mi:ss') LAST_START_DATE,ENABLED,STATE from DBA_SCHEDULER_JOBS;
select occupant_name,schema_name,occupant_desc,move_procedure from v$sysaux_occupants;
select tablespace_name,status,sum(bytes)/1024/1024 "Bytes(MB)" from dba_undo_extents group by tablespace_name,status;
--修改一个job的执行时间。
exec dbms_scheduler.set_attribute('DELETE_AUDIT_TRAIL_JOB','NEXT_RUN_DATE',to_date('2012-10-29 13:00:00','yyyy-mm-dd hh24:mi:ss'));
--查询scheduler job的执行详细
SELECT log_id, job_name, status,TO_CHAR(ACTUAL_START_DATE,'yyyy-mm-dd HH24:MI:ss') start_date,
TO_CHAR (log_date, 'yyyy-mm-dd HH24:MI:ss') log_date
FROM dba_scheduler_job_run_details;