Need to run a script everyday at 5 am, how can I?

[Elayne Stewart]

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

[bruceR]

You create the schedules in Server Admin.

[Elayne Stewart]

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???

[Elayne Stewart]

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!

[bruceR]

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.