Latest Activity

code

Denodo detect new table and create metadata

Can Denodo detect when new table are added to the existing database that is already connected to denodo and automatically create metadata of that table in denodo?

#Scheduler #SchedulerAPI #metadata

code

Misfire on Scheduler Job

Hi, On scheduler I keep seeing Misfire result on the Job when I have Trigger scheduled. I went through the causes but it doesnt really satify the scenarios I see. Is anyone having this kind of problem? Thank you, I hope I can be more clear but dont...

#Scheduler #misfire#Job

code

Negative number in extracted tuples in scheduler

Hello, I am using the Denodo 8 scheduler. The scheduler job that I ran completed successfully but I see this number in the extracted tuples section '-1044435686' , what does the negative number mean? Thanks!

#Scheduler

code

Scheduler VDP Rows returned

How do you return values from a VQL in Scheduler and email the values?

#scheduler

code

Cache job for a view with dynamic where clause

Hello, I have a view that I would like to cache with a where clause, so that it picks up only a few rows. For example: select from test_view where test_log_id > *max(test_log_id) CONTEXT('cachepreload'='true', 'cachewait_for_load'='true', 'cache_...

#cache #scheduler

code

Checking the datasource connection in Scheduler

Is there a way to test the datasource connection in scheduler. one checkbox is provided for "Test connections" in data source details, which doesn't provide any indication that connection is successfull or failed?

#Scheduler

code

Scheduler Admin Back end table Details

Hi Team, Wanted to check if the Scheduler Admin maintains all the field attributes/Metadata in any back end DB, or any other location where it maintains the metadata of the Code. The idea is to query that particular table which contains this Schedule...

#Scheduler #metadata #SchedulerAdminDetails

code

Email notification on scheduled job failure

How to setup notification for any job failure scheduled via Denodo Scheduler ?

#Scheduler #Email #Notification

code

Scheduler email-exported-files handler does not send email when there is an error

We are using a scheduled job to execute source_changes() to notify via email when any base view(s) no longer match their underlying data source. It works great when there are no errors, such as connectivity issues on the data source of any base views b...

#Scheduler

code

Denodo scheduler with cached views queries.

Hi team, I'm a Denodo7 admin and wanted to know how can I validate the views that are cached have a corresponding schedule that keep the cache up to date? For example I can use CACHECONTENT() to see last it was 'full' cached but is there a existing job?

#Scheduler #cache