Job just stops running mystery!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Job just stops running mystery!

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    Job just stops running mystery!

    9.2, Solaris

    I just can't figure out why one particular dbms_job just stops running without any clues?

    - The job is hourly
    - The job runs successfully for 1 or 2 days every hour
    - plenty of job_queue_processes (20)
    - it's always the same job
    - nothing in the alert log!
    - We have a commited insert at the top and bottom of the proc with start and stop time.
    .
    .
    .
    BAT_RPT_CA_ORDER_SUMMARY BEGIN 2/11/2003 11:50:04 PM
    BAT_RPT_CA_ORDER_SUMMARY END 2/11/2003 11:51:16 PM
    BAT_RPT_CA_ORDER_SUMMARY BEGIN 2/12/2003 12:50:03 AM
    BAT_RPT_CA_ORDER_SUMMARY END 2/12/2003 12:51:10 AM
    THEN IT JUST STOPS!!!

    What else can I look for? One thing I not do before I manually ran the job was check failures in DBA_JOBS.
    Last edited by gopi; 02-12-2003 at 11:14 AM.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    Look at the dba_jobs.failures -Column, after 18 Times
    the Job-Subsystem sets automatically the job broken.

    Orca

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    thanx orca,

    the very first thing we do when this happens is look in the broken column and it has always been = 'N'

    to get the job to run again all i have to do is change the next date.

    so mysterious!

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Orca777
    Hi,
    Look at the dba_jobs.failures -Column, after 18 Times
    the Job-Subsystem sets automatically the job broken.

    Orca
    18? I think 16.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.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