I need the Adapter State and Status of the business operation, which I do not see in the provided query.

How can I retrieve the Job Status when it is an error, along with the adapter text? In my case, I am looking for 'Error' and 'Disconnected' from my above image.

Thanks

What would the SQL query look like to retrieve the individual schema names from this list? Ideally, I want to export each of these as a separate objects instead of the one large object under ^EnsHL7.Schema

Perfect. Thank you.