Job schedulers

Contact

Tools for centralising activities are effective tools for the management and administration of daily data processing. They help to simplify the complex administration of large data warehouses and they help to reduce the number of IT staff. What are the main benefits of these tools?

  • Centralised launching of various types of tasks on different technologies and monitoring of their execution.
  • Defining the dependencies and maximum parallelisation of running processes that are not dependent on each other.
  • Setting up of audit tasks with the required notifications and alerts.
  • Atomicity of individual tasks and a clear and structured definition of all dependencies in a single place, i. e. a significant simplification of the impact analysis and an easy integration of new tasks into the process.
  • Performing of all administrative interventions from the user console, i. e. rapid identification of errors in processing and their impact.
  • Administration of all configuration parameters from the user console.

    A job scheduling tool for massively parallel processing designed for heterogeneous data warehouse environments. It is built over a Java application server. Process management in GTL Scheduler is based on the definition of dependencies between tasks and resources (for example, locks, files, spreadsheets, etc.). Tasks are launched as soon as their dependencies on other tasks and objects are fulfilled. Specific arrangement and parallelisation size are left to the tool responsible for the process control. User interface as a web application use different user roles and allows daily data processing monitoring and administration. Job scheduler - dependency graph One of the…

    Job scheduler GTL Launcher allows automation of launching tasks (databases procedure and ssis packages procedures) in environment of Microsoft SQL server 2005 and higher. Its typical use is in cases of regular (daily, monthly...) launching all the time the same tasks, eg. downloading of extracts into database, export data from one database to the other or other etl. Its performance unit consists of a series of management database tables and t-sql saved procedures. The launch of task is provided by sql server agent. Job scheduler user interface (user console) has character of web application, is created in c# asp.net 2.0.…