比如出现了下面的错误,怎么解决呢
- SELECT JOB,WHAT,LOG_USER,TO_CHAR(LAST_DATE,'YYYY-MM-DD HH24:MI:SS'),TO_CHAR(NEXT_DATE,'YYYY-MM-DD HH24:MI:SS'),INTERVAL,FAILURES,broken from user_jobs;
- JOB WHAT LOG_USER TO_CHAR(LAST_DATE,' TO_CHAR(NEXT_DATE,' INTERVAL FAILURES B
- -- ----- --------------------------------------------------- ------------------ ---------- -
- 22 myproc; SCOTT 2011-10-27 21:59:44 2011-10-27 22:11:57 sysdate+1/2440 16 N
解决办法:
1、exec dbms_job.broken(22,false,sysdate+1/2440);
commit;
2、SQL> exec dbms_job.run(22,true);
commit;
如果不想让job立即执行,那么就用第二种。