排JOB實例

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