OS PROCESS is the common ID
Brian Blades, October 20, 2017 - 12:57 pm UTC
Thanks Connor, I didn't think of that, just figured that the session IDs would have been the tie in. Using your process, I found the location of the autosys instance that was running job and the admins have fixed the query by moving it to the database where it should be running, rather than running it over a db link which doesn't allow them to select a LOB column (this was causing the error).