Database Administration (MOSC)

MOSC Banner

JOBs dont starrt at correct time

edited Jan 19, 2011 5:19PM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center