I have a FM 10 DB hosted on a FM Server Advanced platform that I need to get to run a scriptdatabse everyday at 5 am and again at 12 noon to convert ODBC source records into usable records in the DB. At 5 am, no one is in the database but at 12 noon there may be people in the database. Any ideas on how I can do this? I looked into Install OnTimer Script, but this only works when a window is open, so that might work for the 12 noon, but what about the 5 am? I am sure that someone has done this and could help quite quickly!

I guess I could have it run the script when the 1st person opens the database, but would prefer not to have it in the open script. Any ideas would be great!

Elayne

You create the schedules in Server Admin.

I set up a schedule on the server and now I get an error 643, unsupported script step. My script runs a loop process that sets variables with data from one table, goes to a new table and then creates a record in a new table and pastes the variables into the new records. The script runs fine when triggered in FM client. I have read that the server side script schedule does not like the exit loop after last step iin a loop, but I thought that the error was 101 for that. How do I isolate the unsupported script step???

ok, so it was my display message box and I figured it out. Thanks for allowing me to put my thoughts in written form and get this wroking!

I set up a schedule on the server and now I get an error 643, unsupported script step. My script runs a loop process that sets variables with data from one table, goes to a new table and then creates a record in a new table and pastes the variables into the new records.

Paste? Not a good idea. Copy/paste should pretty much be eliminated, use set field.