How do I add a VDB Cache Refresh job to the Denodo Scheduler?

On this page:

Accessing the Scheduler

To access the Denodo Scheduler:

  1. To open the stage scheduler, navigate to
  2. You'll have to log in on two different pages. On the first login page, enter guest for both "Login:" and "Password:", and then click Accept.
  3. To the right of the Scheduler server, click Connect.
  4. On the second login page, enter your IU username and passphrase; be sure local authentication is unchecked.
  5. Click Accept.

Adding a VDB Cache Refresh job

To add a VDB Cache Refresh job to the Denodo Scheduler:

  1. On the right side of the menu bar, click Projects:
    Denodo Scheduler
  2. Select your project.
  3. Click NEW JOB and then, from the drop-down menu, select VDPCache.
  4. In the "Job name:" field, enter a name for your job, and in the "Job description:" field, fill in a job description.
  5. At the top, select the Extraction section tab.
  6. Choose your data source. Data sources will be named xx_xxxx VDB, where xx_xxxx is the name of your virtual database (VDB).
    If you don't see your data source listed, contact EDSS using the EDSS Support Form.
  7. Click New Load Process.
  8. Next to "View:", click Cycle. You'll see the message, "Views for selected data source have been updated".
  9. Select your view.
  10. Add criteria as needed, and then click Save.
  11. To set mail notifications, select the Handlers section tab.
  12. Click New Handlers, and then select Mail from the drop-down menu.
  13. Fill in the options as appropriate, and then click Save.
  14. To access scheduling, select the Triggers section tab.
  15. Click New Trigger.
  16. In the "Cron expression:" field, enter the cron expression; alternatively, use the cron-like UI to specify when the extract should run. For instance, you can specify a particular minute and hour of the day, which will schedule the extract to run daily at that time.
  17. Click Save.

To learn more, see the Denodo Scheduler Administration Guide. For assistance with the Denodo Scheduler, contact EDSS using the EDSS Support Form.

This is document alqf in the Knowledge Base.
Last modified on 2018-07-05 12:31:22.

Contact us

For help or to comment, email the UITS Support Center.