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
| create or replace procedure test_sofiane (p_fic IN varchar2) as
BEGIN
DBMS_JOB.iSUBMIT('1553', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate , 1);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1554', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate , 2);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1555', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,3);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1556', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,4);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1557', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,5);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1558', 'INSERT INTO RBVQTMER(QI_FILIAL, ANNO , MES, TYPE_VPVU, MERCADO) SELECT QI_FILIAL, ANNO , MES, TYPE_VPVU,MERCADO FROM RBVQTMER_LOAD;' , SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1559', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,6);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1560', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,7);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1561', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,8);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1562','INSERT INTO RBVQTMME(QI_FILIAL, FECHA ,TYPE_VPVU ,USUARIO, FECHA_MOD , MERCADO )SELECT QI_FILIAL, FECHA ,TYPE_VPVU ,USUARIO, FECHA_MOD , MERCADO FROM RBVQTMME_LOAD ;', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1563', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,9);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1564', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,10);', SYSDATE, 'SYSDATE + 10/1440');
DBMS_JOB.iSUBMIT('1565', 'insert into test (DATE_CHARGEMENT, ROBUSTEZ0 ) values (sysdate ,11);', SYSDATE, 'SYSDATE + 10/1440');
commit;
end test_sofiane; |
Partager