dbms_scheduler job logs not found Oracle 10g R2
RRSOra?Apr 19 2012 — edited Apr 20 2012Hi,
I created a script in dev in Oracle 10g R2 using dbms_scheduler and the script ran successfully. I was able to verify the logs in all_scheduler_job_run_details in dev. However when I moved the script to QA environment and executed the same, the following happened: A chain step in the script to update request to WIP was executed successfully. I was able to verify the status from table. However I did not find any logs in all_scheduler_job_run_details in QA nor did I find any details in all_scheduler_programs or all_scheduler_chains or all_scheduler_chain_steps. Is there a possibility that someone like some DBA might have turned logging off deliberately in QA or is there any other scenario or situation due to which this might have occured? I am executing an external job too and it executes fine in dev. However in QA, the external job is not executed. I confirmed that CREATE EXTERNAL JOB privilege is granted to schema in QA?