Ask Dr. SQL: task scheduler
April 04, 2003 04:09 AM
Mark’s Überselect:
We are writing a scheduler, which needs to decide which tasks to run. The scheduler is run once a day. Tasks which have not been started, should be run now, along with all the other tasks whose starting date will come up before the scheduler is run again. Tasks that were never completed but whose end date has already passed, should not be run. (Yes, this means that some tasks may end up being skipped altogether, if the scheduler slips. For reasons known only to management, this is acceptable and even desired.) … This is a real-world example. I couldn’t possibly make up something this contrived.
