oracle-创建JOB

      ---

--创建job

DECLARE



  JOB NUMBER;

BEGIN

  DBMS_JOB.SUBMIT(JOB,

                  'PROC_UPDATE_RESERVED_RESE_INFO;',

                  TO_DATE('31-07-2015 01:00:00', 'dd-mm-yyyy hh24:mi:ss'),

                  'sysdate+1/24');

  COMMIT;

END;

--执行job

BEGIN

  dbms_job.run(407);

END;

--查看job

SELECT JOB,

       LOG_USER,

       TO_CHAR(LAST_DATE, 'yyyy-mm-dd hh24:mi:ss') LAST_DATE,

       TO_CHAR(NEXT_DATE, 'yyyy-mm-dd hh24:mi:ss') NEXT_DATE,

       INTERVAL,

       WHAT

  FROM USER_JOBS

  WHERE what = 'PROC_UPDATE_RESERVED_RESE_INFO;'