Latest Activity

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

code

How to get "Result" values from jobs in Scheduler

We are trying to get the history detail for each job using the scheduler API. We are able to get the start time using the JobReport.getStartTime p.e. However, we are not able to get the "Result" values (COMPLETE, ERROR etc) for each execution in the ...

#Scheduler #SchedulerAPI

code

Webservice and scheduler

How to check if web service is up and running from scheduler?

#Scheduler