Found many jobs has been scheduled in the database level and I am not able to identified for which schema, what he has scheduled.
I can’t ask him for all details and his response is also poor. So I need your input here
1.) How can we know what tasks has scheduled in last 10 days
2.) Script of tasks and result of tasks
I'm a bit confused by your question. I'll make some comments, but let me know if I have not answered what you want.
1) Created in the last 10 days.
DBMS_JOB : I don't think there is a record of the job creation time anywhere.
DBMS_SCHEDULER : Try the DBA_SCHEDULER_JOB.START_DATE.
2) Script of tasks:
DBMS_JOB : Look at the DBA_JOBS.WHAT column to see what the job does.
DBMS_JOB : Look at the DBA_SCHEDULER_JOBS.JOB_ACTION column to see what the job does.
3) Result of tasks:
DBMS_JOB : The FAILURES and BROKEN columns in DBA_JOBS give you some indication problems. Sometimes, job failures are sometimes written in the alert log and trace files, depending on the cause.
DBMS_SCHEDULER : The STATUS and ERROR# columns of the DBA_SCHEDULER_JOB_RUN_DETAILS view tell you the result of the each run. Once again, job failures are sometimes written in the alert log and trace files, depending on the cause.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests