forgetso

Sometimes it is necessary to run processes on a web site that make changes to the database on a daily basis. An example of this could be when data needs to be aggregated from a reservations component and made available to an external application or tool, in a format that is user friendly. A script would be written that updates an existing table and then the extenal tool could access this table. This script will work fine as a standalone php file but how do we make sure it is run and how do we make use of the Joomla libraries inside it when it is not being called from within the framework?