Just wanted to see what people here think about this. When a DE job fails it is logged in the database with a state of 'FAILED' but as soon as that job is force completed, it gets updated to 'COMPLETE' with a condition of 'FORCED'. That is great I believe for the most part but how are you to have an accurate count of failed jobs this way?
I'm just looking for a truly accurate way to get the failed jobs. You can't just run a query and pull back a state of FAILED because that will not account for times when it failed but then was force completed. If the job fails then is resubmitted, there is a separate record for that. Should not be a separate record for the force complete as well so you have a more accurate count of the failed jobs?