I've read on a few websites that one of Automators flaws is that it's not possible to schedule Automator to run at specific times. But using iCal, it is:
- Save the Automator workflow as an application.
- Select Add Alarm on a new or current event.
- Select Open File: Other, and open your saved workflow application.
- Enter the time and date that you want the workflow to run.