I would schedule the proc to always run and then get it to check for some other trigger to decide if it needs to actually do anything.

We use a similar idea for scheduled reports which we produce overnight from polled sales data.

- Steve