How to get status of last execution of a scheduler job
Hi,
I am trying to write a pl/sql code that can manually the scheduler job (one time type/ not a repetitive) which are in retry scheduled state.
even after execution is successfull job is not dropped even if i set auto_drop to true.
I need some way to capture execution status of dbms_scheduler.run_job('job_name');. based on which i can manually drop the job if it is successfull.
taking the value from dba_scheduler_job_run_details doesn't seem to be good option as there may be multiple logs and we don't what time interval we need to match.
can anybody help me in this.
Thanks in advance.