OraFAQ Forum: Server Administration » How can I find out why a job did not execute ?

Home » RDBMS Server » Server Administration » How can I find out why a job did not execute ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I find out why a job did not execute ? [message #64382]

Thu, 20 January 2005 15:07

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

I have a piece of code that works fine normally. However when I put it to run as a job it does not execute.
How can I find out the reason ? Is there any field in the dictionary that shows the error message ?

Thanks in advance.

Report message to a moderator

Re: How can I find out why a job did not execute ? [message #64388 is a reply to message #64382]

Thu, 20 January 2005 23:08

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

This may help:

SQL> SELECT job, to_char(last_date, 'dd-mon-yyyy hh24:mi') "LAST EXECUTED ON",
  2         failures, broken
  3  FROM   dba_jobs
  4  /

       JOB LAST EXECUTED ON    FAILURES B
---------- ----------------- ---------- -
         1 21-jan-2005 09:38          0 N
         2 16-jan-2005 01:00          0 N
        21 21-jan-2005 09:42          0 N

Best regards.

Frank

Report message to a moderator

Re: How can I find out why a job did not execute ? [message #64395 is a reply to message #64388]

Fri, 21 January 2005 05:17

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

Thank you very much. But I still have the problem. If the job does not execute where can I look for the error message ? The view DBA_JOB seems not to have a field the shows the error message.

Thanks in advance

Report message to a moderator

Re: How can I find out why a job did not execute ? [message #64396 is a reply to message #64395]

Fri, 21 January 2005 06:13

Frank
Messages: 7901
Registered: March 2000

Senior Member

Did you check your alert log ?

Report message to a moderator

Re: How can I find out why a job did not execute ? [message #64397 is a reply to message #64396]

Fri, 21 January 2005 06:40

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

What do you mean ? Explain it better to me, please. How can I do that ?

Thanks in advance

Report message to a moderator

Re: How can I find out why a job did not execute ? [message #64400 is a reply to message #64397]

Sat, 22 January 2005 00:36

Frank
Messages: 7901
Registered: March 2000

Senior Member

Errors in jobs are written to the alert log.
This is located on your filesystem (it is not a table, but a file). It's location can be found using
select name,value from v$parameter
where name='background_dump_dest';

hth

Report message to a moderator

Previous Topic:	tns-12514 & TNS-03505: Failed to resolve name
Next Topic:	Oracle migration problem from 8i to 9i - URGENT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 14 16:54:28 CDT 2026