Solved Task Scheduler Automation (1 Viewer)

[Pat Hartman]

I pretty much agree with you, but, still cannot see it happening.

Then the OP works for a dumb company or he is afraid to tell them that he doesn't have the time or skill to create a proper scheduler tool. Most of my Access clients have been small (<100) privately owned companies and I've never had a problem with them refusing to buy a tool from FMS and I recommend several of them regularly.

 

[The_Doc_Man]

Chances are excellent that the FMS product actually works. Several of my clients use it to schedule backups and possibly other tasks as well.

Actually, I agree with you, Pat. My comments were strictly for building the "roll your own" type of scheduler.

I built something using the DCL scripting language for the Navy Reserve personnel system because OpenVMS didn't have a periodic task scheduler like Windows does. Never quite figured out why they didn't. Took me a while to refine it, but it was quite easy to set up new tasks with almost any kind of scheduling interval from every 15 minutes to once per year on a particular date at a particular time. All sorts of pitfalls - including what to do if you had something scheduled but we lost power during a time that overlapped the selected run-time. If power was out for more than 1 cycle, I built in the ability to either play catch-up for all of the missed cycles, or schedule once no matter how many intervals were missed, or just skip it if it couldn't run at the exact time. Just one example of how complex things could get.