scheduled jobs details

All posts relating to Oracle database administration.

Moderator: Tim...

scheduled jobs details

Postby royalyogi » Thu Nov 21, 2013 9:25 am

One of application team member has scheduled the jobs to analysed the schema and hope for index rebuild also. But while checking the jobs details using dba_scheduler_job_run_details,dba_jobs….
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
royalyogi
Senior Member
 
Posts: 167
Joined: Tue Apr 23, 2013 3:59 pm

Re: scheduled jobs details

Postby Tim... » Thu Nov 21, 2013 1:27 pm

Hi.

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.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 3 guests

cron