Running Scripts on Filemaker Server Advanced According to Time of Day
I hope there is a simple solution to this problem but I am certainly not seeing it.
I have a Filemaker database that runs a script to pull data from an Oracle data base, configure a report, then email it to a select group of recipients. Right now, these actions are triggered at system start up. When the computer starts up an automator script runs to launch mail, then FMP 9, which in turn runs a scripts that performs these functions. Works great.
However, now that I have Filemaker server advanced, I'd rather just leave the database running on the server machince as a shared database, and perform those tasks every morning at a certain time. It seems like this should be possible, but I'm not seeing the solution. Any ideas on how this can happen would be very welcome.