Light weight workload management server integration

摘要

A method, computer program product and system for workload management for an Extract, Transform, and Load (ETL) system. A priority of each workload in a set of workloads is determined using a priority rule. In response to determining that the priority of a workload to be checked has a highest priority, it is indicated that the workload has the highest priority. It is determined whether at least one logical resource representing an ETL metric is available for executing the workload. In response to determining that the workload has the highest priority and that the at least one logical resource is available, it is determined that the workload is runnable.

主权项

1. A method for workload management for an Extract, Transform, and Load (ETL) system, comprising:
determining a priority of each workload in multiple queues using a priority rule and giving a higher priority to a first workload type over a second workload type, wherein each of the multiple queues is associated with a resource policy; forming a set of workloads by selecting a first workload from each of the multiple queues; selecting a workload from the set of workloads that has a highest priority; identifying the resource policy associated with a queue from the multiple queues that had stored the workload; identifying an ETL metric at a system level, the ETL metric at a queue level, and at least one physical resource using the identified resource policy; and in response to determining that the workload has the highest priority, that the ETL metric at the system level and the ETL metric at the queue level have been met, and that the at least one physical resource is available, determining that the workload is runnable.