I need scheduled script (once per day) that will export all data to SQL table. This SQL table is source for additional requirements (web source, further analysis, etc.).

I have tried to make it successful via FileMaker Server, but it seems that server can schedule only 'web compatible' scripts. And those scripts are only for some operations in database, but not for ANY kind of export or manipulation with external databases. I don't know why exists this limitations...

Scheduling of scripts was main reason for using a new server version, but now it was worthless investment...

Does anybody knows how to trigger (or schedule) a script that can execute SQL at specific time?

Any help would be appreciated!

Executing a SQL script server side is a different item that export data. Server side exports are a FileMaker Server 10 functionality, not a FileMaker Server 9 one. Execute SQL is not a supported step in either version.

See this FMF article for more about Server side import and export.

HTH

Steven

Thank you on your answer.

Is there any option that enables script scheduling, either on database, or on server side? Or setup connectivity (e.g. ODBC) that enables data transfer to SQL Oracle?

Client-side you can schedule scripts to run either with plug-ins or with OS level scripting, e.g. VB Script or Apple Script applets.

Steven