DSXchange

I need to fetch entries from the Job Log where the Warnings matches a pattern for the latest run, can anyone share the name of the Job Log file (I tried using DS_JOBLOGS, it didnt work)

My plan is to fetch the records from the file using UV query with filter conditions on Event Number, Event Type and pattern matching on Event columns of the file

what would be the UV query to describe the UV tables for their columns.

Any help would be greatly appreciated.

Each job has its own log, which is a table in the Repository. The job has a unique number assigned when the job is created, and the name of the table that contains the job log is RT_LOGnnn where nnn is that job number.

Job names are mapped to job numbers in the DS_JOBS table.

Note that job logs are NOT files - they are database tables. To get a list of the column names, the command is: