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

Thread: BROKEN Jobs

  1. #1
    Join Date
    Oct 2021
    Posts
    1

    BROKEN Jobs

    Hi,

    I have a database with thousands of jobs, two of which on occasion go BROKEN. They fail a couple of times before BROKEN, but what I have failed to identify is why they go BROKEN so early. They are the only two jobs that suffer this problem.

    The failures are typically due to database connectivity issues, but this isn't the issue, the issue is that they become BROKEN.

    As I understand BROKEN is expected is a job continually fails. I believe something like 15 times in a row. These 2 go BROKEN after a couple of failures.


    Can someone point me at something that I may be missing please.

    Thanks

  2. #2
    Join Date
    Dec 2002
    Posts
    74
    Not very clear what the problem is. It is hard to troubleshoot intermittent problems, you should consider enabling verbose logging for every process to get more information.

    SQL Net trace reveals errors at connectivity level, may be useful here.

  3. #3
    Join Date
    Nov 2021
    Posts
    8
    emmmm. it's not very clear really. Pls clear it first

  4. #4
    Join Date
    Nov 2021
    Posts
    1
    I've never had such a problem.
    Last edited by maureencurtis; 12-15-2021 at 12:01 PM.

Tags for this 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
  •  


Click Here to Expand Forum to Full Width