DBMS_JOB not running, urgent please help - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 28 of 28

Thread: DBMS_JOB not running, urgent please help

  1. #21
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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!).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  2. #22
    Join Date
    Apr 2002
    Posts
    291
    Thank you jurij,
    i tried it executing manually, but got no errors. It ran for once successfully.
    PNRDBA

  3. #23
    Join Date
    Apr 2002
    Posts
    291
    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

  4. #24
    Join Date
    Apr 2002
    Posts
    291
    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??
    PNRDBA

  5. #25
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Exclamation

    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

  6. #26
    Join Date
    Apr 2002
    Posts
    291
    Ok, Thanks for your politeness. I'll do that.
    PNRDBA

  7. #27
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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]

  8. #28
    Join Date
    May 2002
    Posts
    219
    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)
    yodaDBA@hotmail.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width