Please try :

BEGIN
EXECUTE dbms_job.broken(61,FALSE);
END;
/
COMMIT;

Note : COMMIT is needed.

Thanks,
Madhu.

-----Original Message-----
From: JEFFERY
[mailto:oracledba-ezmlmshield-x62637575.[Email address protected]
Sent: Wednesday, October 04, 2006 4:11 PM
To: LazyDBA Discussion
Subject: RE: ORACLE JUBS STILL BROKEN


Check dba_jobs_running to see if it was already running when you
executed the command.

If you are on Oracle 8.1.7, also check the number of "FAILURES" in
dba_jobs, if this is '16' you might has to bounce the database.

I've had similar issues with replication 'jobs' where if "FAILURES" = 16
I was toast because of some BUG.

Good luck

Jeff

-----Original Message-----
From: oracledba-return-133106-JEFFERY.L.SCHRENK=saic.[Email address
protected]
[mailto:oracledba-return-133106-JEFFERY.L.SCHRENK=saic.[Email address
protected]
On Behalf Of Qi cheng
Sent: Wednesday, October 04, 2006 11:59 AM
To: LazyDBA Discussion
Subject: ORACLE JUBS STILL BROKEN

after issue: EXECUTE dbms_job.broken(61,FALSE);

the job seems still broken.

Any ideas?

Thanks.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Note: The information contained in this email and in any attachments is
intended only for the person or entity to which it is addressed and may
contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in
reliance upon, this information by persons or entities other than the
intended recipient is prohibited. The recipient should check this email and
any attachments for the presence of viruses. Sender accepts no liability
for any damages caused by any virus transmitted by this email. If you have
received this email in error, please notify us immediately by replying to
the message and delete the email from your computer. This e-mail is and any
response to it will be unencrypted and, therefore, potentially unsecure.
Thank you. NOVA Information Systems, Inc.

Oracle LazyDBA home page