Jedox Scheduler

Jedox Scheduler is an automation component within the Jedox Suite, designed to manage and execute scheduled tasks such as data loading, report distribution, and database maintenance, enhancing operational efficiency and ensuring data freshness. Its integration with Jedox Integrator and support for custom scripts and event-triggered execution make it a vital tool for maintaining the reliability and performance of Jedox-based business intelligence applications.

Challenge

Jedox Scheduler is a critical component of the Jedox Suite, designed to automate and manage the execution of various tasks within the Jedox environment. Its primary function is to ensure that repetitive and scheduled tasks, such as data integration jobs, report generation, and database maintenance activities, are performed efficiently and without the need for manual intervention. By leveraging Jedox Scheduler, organizations can improve their operational efficiency, ensure data freshness, and maintain optimal performance of their Jedox-based applications.

Core Features and Capabilities

Task Scheduling

Jedox Scheduler allows users to define and schedule tasks to run at specific times or intervals. This includes daily, weekly, monthly, or even more complex scheduling patterns. It supports the automation of a wide range of tasks, including data loading, ETL processes, report distribution, and execution of scripts.

Integration with Jedox Integrator

A key feature of Jedox Scheduler is its tight integration with Jedox Integrator, enabling automated execution of ETL processes defined within Jedox Integrator. This ensures that data within Jedox OLAP server is always up-to-date and consistent, facilitating accurate analysis and reporting.

Integration with Jedox Modeler

Integrating Jedox Scheduler with Jedox Modeler and configuring scheduled database backups involves leveraging Jedox Scheduler's capabilities to automate the process of backing up databases managed by Jedox Modeler. This process ensures that the multidimensional databases, which store critical business intelligence data, are regularly saved to secure locations, mitigating data loss risks and facilitating data recovery when necessary.

Integration with Reports

Integrating Jedox Scheduler with report distribution involves setting up scheduled tasks within Jedox Scheduler to automatically generate and send out reports at predefined intervals, ensuring stakeholders receive timely insights without manual intervention. This process leverages Jedox's capabilities to pull the latest data, generate reports based on current templates, and distribute them via email or save them to specified locations accessible to the intended audience.

Notification and Templates

When it executes tasks, the Scheduler sends email notifications that can be configured to use variables in Jedox Web. These emails can contain information about task name and status, ETL job or project names, start date/time, end date/time, duration and error messages that have occurred during the task. Additionally, users can edit an existing template by selecting it from the list and making changes in the text editor.

Monitoring and Logs

Jedox Scheduler includes comprehensive logging and monitoring capabilities that track the execution details of scheduled tasks, including start times, end times, execution status, and any errors encountered. These logs are essential for administrators to audit system activities, troubleshoot issues, and ensure the reliability of automated processes within the Jedox environment.