JOB管理

1.SELECT WHAT,INTERVAL,LAST_DATE,NEXT_DATE,JOB,BROKEN FROM DBA_JOBS ORDER BY 1;

2.如BROKEN=N

   BEGIN DBMS_JOB.NEXT_DATE(3, SYSDATE+(5/24/60/60));END;

   BEGIN DBMS_JOB.NEXT_DATE(10,SYSDATE+(5/24/60/60)); END;

  

   如BROKEN=Y

    BEGIN DBMS_JOB.BROKEN(3,FALSE, SYSDATE+(5/24/60/60)); END;

     BEGIN DBMS_JOB.BROKEN(10, FALSE, SYSDATE+(5/24/60/60)); END;

COMMIT;

3.強制RUN Job

BEGIN DBMS_JOB.RUN(22); END;