DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Job just stops running mystery!

  1. 02-12-2003, 09:29 AM #1
    gopi's Avatar
    gopi
    gopi is offline Tree Hugger
    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.
    Reply With Quote Reply With Quote
  2. 02-12-2003, 01:29 PM #2
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    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
    Reply With Quote Reply With Quote
  3. 02-12-2003, 02:16 PM #3
    gopi's Avatar
    gopi
    gopi is offline Tree Hugger
    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!
    Reply With Quote Reply With Quote
  4. 02-13-2003, 05:59 AM #4
    julian
    julian is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width