Skip to main content
To homepage To homepage
Solved

Backend table for the ODX Execution Log

  • April 11, 2024
  • 1 reply
  • 126 views
M
Explorer

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. 

 

Best answer by rory.smith

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: 

 

View original
Did this topic help you find an answer to your question?

1 reply

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 649 replies
  • Answer
  • April 11, 2024

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: 

 

Thomas Lind
1 person likes this
  • Thomas Lind
    Thomas Lind

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings