这是个自动收集STATS的作业, 我重建了, 还是用MAINTENANCE_WINDOW_GROUP的计划. 但是看对象的统计信息并没有更新. SCHEDULER_JOB_LOG中也没有显示成功或失败. 没有记录.
手动执行, EXEC DBMS_SCHEDULER.RUN_JOB ('GATHER_STATS_JOB'); 可以成功完成,
exec DBMS_SCHEDULER.create_job ( job_name => 'GATHER_STATS_JOB',program_name => 'GATHER_STATS_PROG', SCHEDULE_NAME=>'MAINTENANCE_WINDOW_GROUP',enabled=> TRUE,auto_drop=>FALSE);
EXEC DBMS_SCHEDULER.set_attribute ( name => 'GATHER_STATS_JOB', attribute => 'RESTARTABLE', value => TRUE);
SELECT JOB_NAME,AUTO_DROP,RESTARTABLE ,STATE,program_name,schedule_name,LAST_START_DATE ,NEXT_RUN_DATE from dba_scheduler_jobs;
JOB_NAME AUTO_ RESTA STATE PROGRAM_NAME SCHEDULE_NAME L AST_START_DATE NEXT_RUN_DATE
------------------------------ ----- ----- --------------- ----------