dbms scheduler - How to run failed step in chain in Oracle using previous job name? -


i have job runs chain. chain consists of 5 steps. first step run , if succeeds, 3 other steps run (independently, in parallel). if 3 steps succeed, last step start. works fine.

i test case error. intentionally provided error in 1 of 3 above-mentioned steps. result, first step succeeded 3 steps run. expected, 2 of them succeeded , third 1 failed. steps working automatically generated job_name (i checked job_name querying user_scheduler_job_run_details). removed intentional error , ran failed step using:

dbms_scheduler.run_chain(chain_name => 'my_chain', start_steps => 'my_failed_step'); 

of course, failed step succeeded (because error removed). step run automatically generated job_name , unfortunately last step (which run after 3 mentioned steps succeed) not run. run failed step specific (previous) job_name, , result, last step should run automatically.

how can run failed step in chain in oracle using previous, specific job name?


Comments

Popular posts from this blog

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

python - How do I create a list index that loops through integers in another list -

c# - “System.Security.Cryptography.CryptographicException: Keyset does not exist” when reading private key from remote machine -