0 Replies Latest reply: May 8, 2013 5:11 PM by 934896 RSS

    STart Date

    934896
      I have this create_job

      BEGIN

           dbms_scheduler.create_job(job_name =>'ETL_TEST_JOB',
      job_type => 'CHAIN',
      job_action => 'ETL_TEST_CHAIN',
      start_date => '08-MAY-13 5.45.00PM',
      repeat_interval => 'FREQ = MINUTELY; INTERVAL=30; BYHOUR = 6,7',
      enabled => TRUE,
      comments => 'Run tests for source and target data.');
      END;
      /

      The start date is '08-MAY-13 5.45.00PM', repeat_interval => 'FREQ = MINUTELY; INTERVAL=30; BYHOUR = 6,7',

      It is supposed to fire once at 5:45PM, and then at 6PM and then at 6:30 PM. and then at 7PM.

      I ran this select * from user_scheduler_jobs;

      and it clearly indicates it is supposed to run at 5:45 PM. BUt it did not run, is there any way to find out what happened to the scheduled job,

      I ran this
      SELECT *
      FROM dba_scheduler_job_run_details
      WHERE job_name = 'ETL_TEST_JOB'
      ORDER BY REQ_START_DATE desc; and I do not see it there as well.