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;'