Execute a folder action on a schedule
You could use Lingon (Mac App Store link) to set up a schedule to run the Automator action (or pretty much any other program/command for that matter). It's a GUI interface to the launchd command that allows scheduling by time, or on specific events (I believe system start/wake is one of them).