For anyone who read my example above (user wondering about what an "Inconsistent" state means), here is a quoted answer from my previously opened support ticket on that particular question, which I assume/hope not everyone would have access to
I generally see this status if the Automation Engine has lost connection to the Database mid execution. In addition, I have also seen this status if the Automation Engine or Database has moved location while jobs are queued/running.
Most of the time, this is seen after a hard AE crash when the MQ tables were processing requests while the DB was lost.
This differs from Ended_lost because the AE is able to find the Job/Agent but the data is not consistent with what the database is expecting.