-
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
-
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.
-
emmmm. it's not very clear really. Pls clear it first
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|