I don't use Automator, but as I understand things it is for automating "work flows" and not for scheduling. You can use iCal for scheduling or you can use cron.

I use cron for this kind of thing. I have never used iCal events to run programs, but some people apparently do it that way.