Better visibility of existing job schedules

In the interests of avoiding record locking with secondary tasks a client would like to be able to see

  1. an alert/info box when saving a new job that it clashes with the time of an existing job

  2. A visualisation or time line when jobs are running and their duration over a 24 hour period.


examples:-

Currently I could create a single global change with two jobs running at exactly the same time and as such cause a lock condition.


Most databases have resource heavy processes running at night. It would be helpful to see where scheduled task A overlaps with scheduled task B or where there is a window to schedule a new data intensive task. Currently we need to check the last run on the individual task and it would be helpfull to see all jobs within a timeline.

  • Guest
  • Jun 20 2023
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) blackbaud
Reported Version 4.0
  • Attach files
  • Will Mercer commented
    August 29, 2023 11:19

    I've written a customisation which allows us to output some of this data in a datalist. It might not cover everything you need, but I'd be happy to share it if you'd like - will.mercer@ucl.ac.uk