2 Replies Latest reply on May 12, 2014 7:32 AM by GregV

    Oracle Scheduler Steps End time (log_date) is completed with lag ?

    user647819

      We have a job with 4 steps

       

      CRM_STG_S1,CRM_STG_S2,CRM_STG_S3,CRM_STG_S4

       

      each step will start after its previous got completed , and each will run for 10 Mins no other dependency or condition,

       

      I started the steps at 1.05 PM

       

      Here the step one got started at  1.00 PM , and it got succeeded at 1.10 PM , but when I check the Program direct log (from Unix) it is completed at 1.10 PM 

       

      The data of DB log (all_scheduler_job_run_details)  : <UPDATE>

       

      JOB_NAMEJOB_SUBNAMEACTUAL_START_DATELOG_DATERUN_DURATION

      --------------- --------------- -------------------------------------------------- -------------------------------------------------- -     -------------------                      

      KONPRD_CRM_JCRM_STG_S102-MAY-14 01.05.01.762000 AM EUROPE/HELSINKI02-MAY-14 02.17.38.728935 AM +03:00+000 00:32:20
      KONPRD_CRM_JCRM_STG_S105-MAY-14 01.05.05.278000 AM EUROPE/HELSINKI05-MAY-14 02.04.01.959036 AM +03:00+000 00:26:38
      KONPRD_CRM_JCRM_STG_S106-MAY-14 01.05.00.482000 AM EUROPE/HELSINKI06-MAY-14 01.52.21.779871 AM +03:00+000 00:24:30
      KONPRD_CRM_JCRM_STG_S107-MAY-14 01.05.06.300000 AM EUROPE/HELSINKI07-MAY-14 02.07.26.228115 AM +03:00+000 00:35:34
      KONPRD_CRM_JCRM_STG_S108-MAY-14 01.05.02.927000 AM EUROPE/HELSINKI08-MAY-14 02.18.48.189616 AM +03:00+000 00:29:33

       

      But step two started only at 1.50 PM , I checked for more details and I found the log date of step one, that is finished only at 1.50 PM

      The job itself finished at 1.10 PM , but why the log date is finished at 1.50 PM

       

      Why the lag is happening ? Please help me to find the issue

       

      EDIT (09 May 08:25 EET) :

      Here If we add run_duration to actual_start-date

       

      02-MAY 01.05.01.762000 AM EET  + 00:32:20 = 02-MAY 01.38.08 AM EET

       

      (End_date from user_scheduler_jobs) Result :  02-MAY 01.38 AM EET   ( But see the log date 02-MAY 02.17.38.728935 ) ???


       

      Thanks and regards ,

      Praveeen

       

      Edited to reply for  GregV