JOBs dont starrt at correct time
-------------------------------------------------------------------
code of trigger that creates "JOB"
CREATE OR REPLACE TRIGGER APP_SCHJOB_TRG
AFTER INSERT
ON APPL_PROC REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
ONBS_START TIMESTAMP;
TMP VARCHAR2(100);
onbs_program_name VARCHAR2(100);
MSG VARCHAR2(1000);
BEGIN
COMMIT;
MSG := '(AIATrg) ' || TO_CHAR(:NEW.APP_PROC_ID );
MSG := MSG || ' TMP = ' || TO_CHAR(SYSTIMESTAMP, 'YYYY.MM.DD.HH24.MI.SS.FF') || ' > ';
TMP := OB_UTIL.GET_REP_INTV(:NEW.APP_EX_SEQ);
ONBS_START := SYSTIMESTAMP + TO_DSINTERVAL('0 00:03:00');
onbs_program_name := :NEW.APP_JOB_NAME;
TMP := OB_UTIL.GET_REP_INTV(:NEW.APP_EX_SEQ);