asked on

Scheduled scripts

Hi
I have FM SERVER 11 and I have never been able to run a scheduled script that saves ,in this case a pdf doc and attaches it to an email .I discovered that it cant be done in this way.
I have an On timer script running from FM PRO 11 installed on the PC running FM Server which is fine but I was wondering if there was not a better way.
I have a calendar system in one of the tables which will give me day of week and week numbers. so I could set a looped script to establish the day number and then run the script on the day.I have not tried it yet but thought I would fist ask if there is a better way
Basically I want several reports sent out via email every Monday of the week as pdf attachments containing latest data.
Regards
Chris

ASKER CERTIFIED SOLUTION

Will Loving

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ozbigben

There are a couple of options for PC that I use to schedule things.

Simplest:
In your remote database, add a script that closes the database. On your PC, create a second database with a script that runs when it opens. This script should call the remote script that you want to schedule and then close the remote database and itself. Then all you have to do is set a scheduled task to open that database.

Single database + batch file.
I use a text file to store a text string that is imported by the opening script in the database, the value of which determines which script steps to run. A database close script resets this text file so that your scheduled script is not run... In this way, the script will not run unless the text file is edited first. To automate the script then, you call it from a DOS batch file that first echoes the keyword to start the script into the text file and then opens the database. As before, all you need then is a scheduled task to open the batch file.
e.g.: https://vimeo.com/38144297 (skip to about 2:00)

Krisraychris

ASKER

I have found an old mac and I think it will work .I also have an old version of FM Server 10 as a back up plan but from what I have read it does not allow this action either. One would think this is a fairly basic reporting requirement and that FM would make it available. Guess they have their reasons. As a last resort I will set an Ontimer script on the Server resident version of FM Pro.
As for the second suggestion I not sure if it will work on my system as I am not too keen on switching the DB on and Off.
Thanks for the help