Is anyone aware of a tool for creating optimal schedules for tasks? I have numerous servers, running multiple databases, with various scripts that import and transform data to and from each database.
I'm currently scheduling the various cronjobs by hand, but this is error prone and difficult to account for exceptions, such as a job taking unusually long to run because of an unusually large data load. I'm considering encoding the resources and dependencies between each task, and creating a planner to search for an optimal sequence of task executions so each task is run at a time when it's least likely to interfere with any other tasks.
I've seen Drools Planner, but it's not appropriate due it's immense complexity and overhead.