Creating and Scheduling Jobs

In addition to the “Configuration” perspective, the Denodo Scheduler administration tool presents other additional perspectives: “Projects”, “Jobs” and “Data Sources”.

The aim of these perspectives is to facilitate the definition of data extraction jobs. In particular, it allows projects, data sources, and jobs to be listed/created/modified/deleted (each element type in its particular perspective).

The various elements of the Scheduler work space are organized by projects (Projects screen). A project groups together a list of data sources, and jobs; you can have elements with the same name (case insensitive) in different projects. On the “Project” perspective, a table with the existing projects is shown and a button to add new projects is also available. To add a new project, its name and an optional description need to be specified.

Projects screen

Projects screen

After the installation the project called “default” is automatically created. If other components of the Denodo Platform have been selected in the installation, a properly configured data source for each of them is also included.

To add new elements to the project it is necessary to click on the perspectives “Data Sources”, or “Jobs” (according to the type of the element the user wants to add). The following sections describe the creation/editing screens for the different types of elements in detail.

Moreover, the “Jobs” perspective allows you to monitor in real time the execution status of the various jobs that have been scheduled. It also allows you to find out the status of the last execution (see prior execution reports), force the execution of a job at a given time or delete its execution, among other things.

In the following sections all the perspectives are described in detail.