I have made a copy of our production Tidal database for reporting and analysis purposes. One of the things that I would like to do is to get a list of our current production jobs that are enabled and the date/time of the last time it ran (successfully or not). How could I get that schedule information as to the last time the job ran from the Tidal database tables? Is this possible from a database query?
The goal is to get a list of enabled jobs that have not run in several weeks/months, most likely due to not having its file dependencies met, to see which of those can be disabled or removed completely. There may be cases where clients are no longer sending us files (maybe because they are no longer clients) that have Tidal jobs set up to process them, so we can get rid of them to clean up our list of Tidal jobs. Any help with this would be appreciated.
