Hello,
I am looking for some SQL Select queries to slice and dice events happening in Tidal and was wondering if anyone had done some work in this area.
Am interested in being able to track a history of Tidal jobs (by Job class - for a data range) because of the volume of records that might be returned.
[1] Basically being prompted for a date range and job class, return back all incidences of a specific job class of logged entries, if this makes sense.
[1.a] Also, in my environment, I have two instances of Tidal agents running on the same server and being able to understand which instance was running which job would be good.
[2ndly] Looking to find any job (definitions, job activity or other places) where entries exist of the Tidal variables, embeded or used.
That would include job activities and/or job definitions. (Looking to weed out stale variables I possibly might have overlooked).
Thanks!
