1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| BEGIN
SYS.DBMS_JOB.REMOVE(11);
COMMIT;
END;
/
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'BEGIN
SYS.DBMS_JOB.REMOVE(9);
COMMIT;
END;
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => ''DECLARE temp VARCHAR2(10000); BEGIN temp :=CALCUL_SECU_PUITS(); END;''
,next_date => to_date(''04/04/2015 15:49:38'',''dd/mm/yyyy hh24:mi:ss'')
,interval => ''NEXTDATE_SECUPUITS''
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE(''Job Number is: '' || to_char(x));
COMMIT;
END;
'
,next_date => to_date('08/04/2014 09:48:55','dd/mm/yyyy hh24:mi:ss')
,interval => 'null'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END; |
Partager