Solved

Backend table for the ODX Execution Log

  • 11 April 2024
  • 1 reply
  • 49 views

Hello,

In Timextender there is a report called ODX Execution Log (see image). I was wondering in which tables the underlying data is stored.

My company has a dashboard / chat bot that we use to check on our nightly DWH executions. For this we use the tables ExecutionPackageLogs, ExecutionPackageLogDetails, Projects, etc.

I want to expand these reports with data regarding the ODX Transfer Tasks. I checked most of the tables in the metadata database (e.g. ScheduleJobs, ScheduleJobLogs) but I was not able to find it. 

 

icon

Best answer by rory.smith 11 April 2024, 16:19

View original

1 reply

Userlevel 6
Badge +7

Hi @Mvest ,

 

in 20.10.x this is stored in the SQLite backlog that is synched from the cloud repository: https://legacysupport.timextender.com/hc/en-us/articles/360054444552-How-to-Query-ODX-local-Backlog-SQLite-database in 6xxx you can get Job logs through the API: 

 

Reply