OraFAQ Forum: Server Administration » dba_jobs stopped running (2 Merged)

Home » RDBMS Server » Server Administration » dba_jobs stopped running (2 Merged) (Oracle db 10.2.0.4, OS : RHEL 4 As)

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

dba_jobs stopped running (2 Merged) [message #495489]

Sat, 19 February 2011 22:59

skothapally
Messages: 2
Registered: February 2011

Junior Member

Hi,

I have a dba_job that is scheduled to run every hour and for the past couple of weeke it is behaving strangely. It fails running every alternate hour. I have checked the alert log whenever it fails but nothing is reported in the alert log. The job is not broken. Any ideas on how to troubleshoot this issue ???

Waiting for a quick response.

Thanks.

Report message to a moderator

Re: dba_jobs stopped running [message #495491 is a reply to message #495489]

Sat, 19 February 2011 23:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Waiting for a quick response.
Based upon the plethora of posted details, I suspect something is wrong; but I can't be sure.

Use COPY & PASTE so we can see what you do & how Oracle responds.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: dba_jobs stopped running (2 Merged) [message #495511 is a reply to message #495489]

Sun, 20 February 2011 03:37

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

I am extremely sorry of this response is not quick enough. Please forgive me.
Even if there is nothing in the alert log, you might have something in a trace file, can you check for any trace files generated at the time the job didn't run?

Report message to a moderator

Re: dba_jobs stopped running (2 Merged) [message #495533 is a reply to message #495511]

Sun, 20 February 2011 13:32

skothapally
Messages: 2
Registered: February 2011

Junior Member

SQL> exec dbms_job.broken(693,TRUE);

PL/SQL procedure successfully completed.

SQL> exec dbms_job.broken(JOB=>693, NEXT_DATE=>SYSDATE + 1/24, broken=>FALSE);

PL/SQL procedure successfully completed.

SQL>

Report message to a moderator

Re: dba_jobs stopped running (2 Merged) [message #495536 is a reply to message #495533]

Sun, 20 February 2011 14:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>It fails running every alternate hour

post SQL & results that provides proof above is true.

Report message to a moderator

Previous Topic:	INDEX CREATION - PARALLEL
Next Topic:	how to install oracle 8i and 9i databases on same server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 01:19:18 CST 2025