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

Thread: BROKEN Jobs

Hybrid View

  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
    72
    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.

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