排JOB實例-优快云博客

本文链接：https://blog.youkuaiyun.com/zeromess/article/details/106156527

本文详细介绍如何在Oracle数据库中使用DBMS_JOB包创建和管理定时任务，包括设置任务的执行时间、间隔以及参数传递，适用于数据库管理和维护场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

JOB1:

DECLARE
    x   NUMBER;
BEGIN
    BEGIN
        sys.dbms_job.submit(job => x, what => '
DECLARE
  IN_I_RUN_TYPE INTEGER;
  IN_S_MFGDATE VARCHAR2(200);
  OUT_S_ERRCODE VARCHAR2(2000);
BEGIN
 IN_I_RUN_TYPE := 0;
 IN_S_MFGDATE := NULL;
 sp_cus_wip_lot_defect_rma(IN_I_RUN_TYPE, IN_S_MFGDATE, OUT_S_ERRCODE);
 COMMIT;
END; '
        , next_date => to_date('2019-05-16 15:55:00', 'yyyy-mm-dd hh24:mi:ss'), INTERVAL => 'TRUNC(SYSDATE+15/1440, ''MI'')', no_parse => false);
    END;
    COMMIT;
END;
/

JOB2:

DECLARE
    x   NUMBER;
BEGIN
    BEGIN
        sys.dbms_job.submit(job => x, what => '
DECLARE
  IN_I_RUN_TYPE INTEGER;
  IN_S_MFGDATE VARCHAR(200);
  OUT_S_ERRCODE VARCHAR(200);
BEGIN
  IN_I_RUN_TYPE := 0;
  IN_S_MFGDATE := NULL;
  MDRDA1.SP_MDSHIS_CUS_LOT_DEFECT_RMA(
    IN_I_RUN_TYPE => IN_I_RUN_TYPE,
    IN_S_MFGDATE => IN_S_MFGDATE,
    OUT_S_ERRCODE => OUT_S_ERRCODE
  );
  COMMIT;
END;'
        , next_date => to_date('2019-05-16 16:26:00', 'yyyy-mm-dd hh24:mi:ss'), INTERVAL => 'TRUNC(SYSDATE+15/1440, ''MI'')', no_parse => false);
    END;
    COMMIT;
END;
/

JOB3:


DECLARE
    x   NUMBER;
BEGIN
    BEGIN
        sys.dbms_job.submit(job => x, what => '
DECLARE
  IN_I_RUN_TYPE INTEGER;
  IN_S_MFGDATE VARCHAR(200);
  OUT_S_ERRCODE VARCHAR(200);
BEGIN
  IN_I_RUN_TYPE := 0;
  IN_S_MFGDATE := NULL;
  MCRDA1.SP_CUS_REASON_MAPPING_RMAINFO (
    IN_I_RUN_TYPE => IN_I_RUN_TYPE,
    IN_S_MFGDATE => IN_S_MFGDATE,
    OUT_S_ERRCODE => OUT_S_ERRCODE
  );
  COMMIT;
END;'
        , next_date => to_date('2019-06-11 23:59:00', 'yyyy-mm-dd hh24:mi:ss'), INTERVAL => 'TRUNC(SYSDATE+1, ''MI'')', no_parse => false);
    END;
    COMMIT;
END;
/