DBMS_JOB not running, urgent please help

[jmodic]

As I said, it means that you have some errors in your procedure CALL_WEEKLY, so that procedure does not run successfully. When this happens, Oracle does not compute NEXT_DATE parameter from your INTERVAL setting. Instead it reschedule the job with a short delay. If also the second time the procedure runs unsuccessfully the job is reschedule with a longer delay. This repeats up to 16 times, allways with doubled delayed time. After 16th failure the job is marked as BROKEN.

Only when a job is run successfully the setting of NEXT_DATE is set according to your interval parameter.

In your case you must find why your procedure runs unsuccessfuly, correct the error and reschedule the job. To find out what is the problem with your procedure, run it manually. In the meantime you better remove that crippled job from your job queue with DBMS_JOB.REMOVE procedure (and don't forget to commit!).

[pnrdba]

Thank you jurij,
i tried it executing manually, but got no errors. It ran for once successfully.

[pnrdba]

Hi Jurij,
Its showing one failure and i pasted the out put over here. Please look into the out put and suggest me what to do , the procedure has no errors and ran successfully when i executed it manually.

Thanks and regards

[pnrdba]

Hi ,
I posted the output of the query what you have given jurij. I got one failure and the job is still running. What to do with this??

[Orca777]

Hi,
i do not want to be unpolite;
You got a lot of help;
But in my mind the discussion exceeds the limit.

Please refer Oracle-Documentation and serarch-possibilities in Internet or visit an administration-course.

Orca

[pnrdba]

Ok, Thanks for your politeness. I'll do that.

[Orca777]

Originally posted by Orca777
Hi,
i do not want to be unpolite;
You got a lot of help;
But in my mind the discussion exceeds the limit.

Please refer Oracle-Documentation and serarch-possibilities in Internet or visit an administration-course.

Orca

Hi PNRDBA!
Sorry for my last posting!
I do not have the right to do this!
please forgive me!
Knowledge made me proud

but

love makes humble.

Orca


[Edited by Orca777 on 07-10-2002 at 04:03 PM]

[yoda]

Get a little taste of your own medicine, or did you get some last night?

"To be humble to superiors is duty, to equals courtesy, to inferiors nobleness."
-- Benjamin Franklin (1706-90)