DECLARE
job3 BINARY_INTEGER;
BEGIN
dbms_job.submit(job3,'BILL_PACKAGE.BILLING;',TO_DATE(TO_CHAR(TRUNC(SYSDATE,'DD'),'dd/mm/yyyy hh24:mi:ss'),'dd/mm/yyyy hh24:mi:ss'),'TRUNC(SYSDATE+1)',FALSE);
dbms_job.RUN(job3);
COMMIT;
END;
/
阅读(665) | 评论(0) | 转发(0) |