| Oracle DBMS_JOB ignore failures [message #146545] |
Thu, 10 November 2005 23:55  |
wzcyc
Messages: 1
Registered: November 2005
|
Junior Member |
|
|
I just want to job to terminate after even one failure.
But it should run scheduled even if it is failed.
No more retry.
|
|
|
|
| Re: Oracle DBMS_JOB ignore failures [message #146644 is a reply to message #146545] |
Fri, 11 November 2005 15:05  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Frankly saying i am not able to understand your question ,,, but if other would have understood your question then uptil now they would have definatly given you solution for your issue,,, it will be better for u to elobarate your question ....? so that we can understand what you are doing ....and where you are getting error...
We all on orafaq.com will try our best to solve your issue.
Regards
Always Friend Sunilkumar
|
|
|
|
| Re: Oracle DBMS_JOB ignore failures [message #146680 is a reply to message #146644] |
Sat, 12 November 2005 03:02 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Explanation is less but if i am getting right then you want that if a job fails then it should not be retried but should run as it was scheduled.
By default , whenever a job fails to execute then Oracle retry to execute the job for 16 times and even then if it fails then its marked as broken.
I am afraid that its not in our control to change this cycle.
see this
| Quote: |
Job Execution Errors
When a job fails, information about the failure is recorded in a trace file and the alert log. Oracle writes message number ORA-12012 and includes the job number of the failed job.
The following can prevent the successful execution of queued jobs:
-- A network or instance failure
-- An exception when executing the job
If a job returns an error while Oracle is attempting to execute it, Oracle tries to execute it again. The first attempt is made after one minute, the second attempt after two minutes, the third after four minutes, and so on, with the interval doubling
between each attempt. If the job fails 16 times, Oracle automatically marks the job as broken and no longer tries to execute it. However, between attempts, you have the opportunity to correct the problem that is preventing the job from running. This will not disturb the retry cycle, and Oracle will eventually attempt to run the job again.
|
regards,
tarun
[Updated on: Sat, 12 November 2005 03:03] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
