Latest Activity

code

Page By/ Group By email Reports in Denodo Scheduler

Hi Team, If the view shows records in below tabular fashion: | Id | Name | Department | | 1 | John | Finance | | 1 | John | Accounts | | 2 | Maria | HR | | 2 | Maria | Facilities | | 3 | David | Legal | Is it possible to send seperate email reports ...

DENODO Denodo Scheduler 6.0

code

Send attachment or job result in mail from Denodo Scheduler 6.0

Hi Team, Can we send mail attachment or job result in email for a job in Denodo Scheduler 6.0. Also can we customize job's mail body for each job in Denodo Scheduler 6.0. Thanks, Akram

Denodo Scheduler 6.0 email

code

Protocol to connect Denodo Scheduler from a third party

Hi Support, We are planning to centralize all the jobs i.e. Windows Task schduler , SQL and Denodo into one. We have planned to use VisualCron for this. Can you help us with the protocol(FTP/SCP/SMTP/POP3/IMAP/SSH/WebDav) to select to connect Denodo Sc...

DENODO Denodo Scheduler 6.0

code

Caching Service Views

There are 14 Service Views in my database which gives data from 2011 - 2018 (joining different combinedviews). We created partial service views for each of the service view by giving a where condition inside the Partial service view (less than 2016 and...

cache DENODO Denodo Scheduler 6.0 SQL Server

code

Keep view names to cached tables

When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Thanks, Sa...

DENODO Denodo Scheduler 6.0 SQL Server

code

Export Denodo Scheduler jobs for the backup

Hi, I'm trying to use the export script to export all the denodo jobs and wanted to schedule the script on weekly basis. But before that when i'm trying to use the export script it throws multiple errors: In Test environment: C:\Denodo Platform\Denodo...

DENODO Denodo Scheduler 6.0

code

Throwing Error in VDP Job Query in Scheduler

Hello, I am working on creating a job inside of Denodo Scheduler that will throw error if a specfic condition is false. Example: CASE WHEN(foo < bar) THEN [throw error] ELSE [keep going]. The reason I am doing this is because I need this job to be ...

Related to: VDP Conformance with Standard SQL

Job scheduler Scheduler Throw Denodo Scheduler 6.0 Error RaiseError

code

Error while sending email through "email-exported-files" plugin

I am trying to send an email through "email-exported-files", but I am getting below error.. “ Handler Errors: {email-exported-files=[Not found parameter: the message cannot be sent. Missing configuration parameter: 'Mail/password']}” Please help me to ...

alert Denodo Scheduler 6.0 email Scheduler Mail Configuration

code

Execution time increased after turning on the Cache

I am having around 20 services created whose base views are cached and indexed. The performance(execution time) of all the services was improved when I switched to cache database except one service. This one service execution time is increased to more ...

performance DENODO Denodo Scheduler 6.0 SQL Server

code

Throwing exception com.denodo.util.exceptions.InternalErrorException: Error executing query

Hello, I am trying to run VDPCache jobs in the Scheduler. For a particular table, I gave the parameters for year column 2001, 2002, 2003......2017 so it can cache one year after the other in a sequence. But, I am seeing an error while the scheduler is...

Denodo Scheduler 6.0 SQL Server