Script that will run automatically every 24 hours

[Jredeemer14]

I have a filemaker solution hosted on a server, but I cannot run server side scripts. I need something in my filemaker database that will run every 24 hours regardless of wether it is open or not by a client. My goal is to have a script that will run every 24 hours and produce an email with an attachment of my current stock for about 12 items. The email and attachment I have created, but I don't know a way to run the script automatically. Any ideas?

[bruceR]

Why can't you run server side scripts?

[Jredeemer14]

it's hosted by online by a 3rd party service and I don't have access to run a server side script on their side. I can of course run as many and I want within my database, but not on their server.

[dansmith65]

Create a new database that performs a script when it opens. That script should perform your email script in the hosted database, then close the current database.

You can use a scheduled task in your OS to open the new database every 24 hours.

[Jredeemer14]

I don't think that would work since many employees open it a couple times a day.

[dansmith65]

I don't think that would work since many employees open it a couple times a day.

I don't think you understand the process, because that's not a valid argument.

The concept is similar to an "opener" file: http://help.filemaker.com/app/answers/detail/a_id/5296/~/how-to-create-a-way-to-quickly-open-networked-files-in-filemaker-pro

Instead of just opening the database, this file performs a script, then closes. Also, it's opened via a scheduled task.

Since you only want the script to run every 24 hours, schedule it to run at night when nobody is using the computer that runs the task.