1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Dbms_scheduler_chain issue

Discussion in 'SQL PL/SQL' started by Girishr369, Nov 13, 2017.

  1. Girishr369

    Girishr369 Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    hyderabad
    Hi Team,
    I am facing an issue with DBMS_CHAIN execution.

    Issue :Even one of the step got Failed, remaining steps were processed with out waiting for depended step SUCCESS.

    Just FYI: I created 2 chains i.e. Chain1 and Chain2 . Calling Chain2 as subchain in Chain1.

    i attached the total script for your reference and below the run details.

    In the below run_details , you can see STEP2 is in failed state but further steps(i.e. STEP3 of CHAIN1 and STEP1 , STEP2 of CHAIN2 got processed)

    Please suggest me on this(what i need to do to hold at FAILED step and how can i RERUN that FAILED step only (or) from Failed Steps)

    upload_2017-11-13_17-16-7.png

    Thanks,
    Ram
     

    Attached Files:

  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    735
    Likes Received:
    145
    Trophy Points:
    830
    Location:
    Russian Federation
    What is shows this query
    Code (Text):

    SELECT s.JOB_NAME,s.JOB_SUBNAME,s.ADDITIONAL_INFO
     FROM user_scheduler_job_run_details s
    WHERE s.JOB_NAME LIKE  'LINKCHAIN%'
    AND s.STATUS = 'FAILED';
     
     
  3. Girishr369

    Girishr369 Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    hyderabad
    Thank you Sergey Krasnoslobodtsev ,

    upon my above query could please provide more clarification on chains. i.e In one chain there 5 steps .Out of 5 steps I need to execute steps from STEP2 to STEP4 only . is it possible. if, YES could yo please provide me how to do.

    Regards,
    Girish