Automatically run a script at night

[kgriff55]

I am hoping there is an easy way to do this that I am overlooking. What I want to do is set a certain script to run at night because it takes about 3 hours to complete. This script checks balances due each day for every invoice and fixes a larger problem that we had. I would like to know if there is an easy way to trigger the script at 5pm every day.

Filemaker Pro 6

Windows XP

[Wim Decorte]

You could use an events plugin, or if you don't like plugins, use a simple VBscript that you can schedule with the Windows Task Scheduler. The VBscript can run a script in FileMaker.

For best results, both approaches require the machine to have the FM files open on a workstation (don't run this on FMS).

Unless you want to go for a more complex router, with the VBscript scheduled to run on the FMS box. The vbscript would then first instruct FMS to close the files, then open the file you need, run the script, wait for completion and tell FMS to start hosting the files again.