« 2012 龙年新年记事 | Blog首页 | 使用dbms_monitor过程执行进程跟踪 »
如何更改SCHEDULER任务的START_DATE时间
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2012/02/scheduler_start_date_set_attribute.html
如何更改一个定时任务的START_DATE / NEXT_RUN_DATE 时间?链接:https://www.eygle.com/archives/2012/02/scheduler_start_date_set_attribute.html
有朋友修改服务器的时间后,所有定时任务停止运行,因为其运行时间处于未来,如下范例:
SQL> select job_name,state,enabled,start_date,next_run_date from DBA_SCHEDULER_JOBS;修复这个时间异常可以使用如下方法,先禁用任务,再通过SET_ATTRIBUTE的方式来修改:
JOB_NAME STATE ENABL START_DATE NEXT_RUN_DATE
------------------------------ --------------- ----- ---------------------------------------- ----------------------------------------
GATHER_STATS_JOB DISABLED FALSE 31-OCT-14 11.18.02.000000 PM +08:00 31-OCT-14 11.18.02.000000 PM +08:00
SQL> exec dbms_scheduler.disable('gather_stats_job');
PL/SQL procedure successfully completed.
SQL> exec dbms_scheduler.set_attribute ('GATHER_STATS_JOB','start_date',systimestamp);
PL/SQL procedure successfully completed.
SQL> select job_name,state,enabled,start_date,next_run_date from DBA_SCHEDULER_JOBS;
JOB_NAME STATE ENABL START_DATE NEXT_RUN_DATE
------------------------------ --------------- ----- ---------------------------------------- ----------------------------------------
GATHER_STATS_JOB DISABLED FALSE 04-FEB-12 11.19.30.550122 PM +08:00 31-OCT-14 11.18.02.000000 PM +08:00
SQL> exec dbms_scheduler.enable('gather_stats_job');
PL/SQL procedure successfully completed.
SQL> select job_name,state,enabled,start_date,next_run_date from DBA_SCHEDULER_JOBS;
JOB_NAME STATE ENABL START_DATE NEXT_RUN_DATE
------------------------------ --------------- ----- ---------------------------------------- ----------------------------------------
GATHER_STATS_JOB RUNNING TRUE 04-FEB-12 11.19.30.550122 PM +08:00 04-FEB-12 11.19.46.692031 PM +08:00
可以看到在启用SCHEDULER之后,NEXT_RUN_DATE会自动计算为正常值。
历史上的今天...
>> 2010-02-06文章:
>> 2009-02-06文章:
>> 2007-02-06文章:
>> 2006-02-06文章:
>> 2005-02-06文章:
By eygle on 2012-02-06 22:04 | Comments (1) | FAQ | 2950 |
这个好东东!学习了