automatically execute procedure in certain time

Hi,

I need automatically execute a stored procedure in a certain time in the night.
This procedure updates records in one table which is depending on other tables. We don't want to execute this procedure every time, when related records are inserted or updated because this procedure is more complicated and it could blockade some other processes.

Is it possible to write a script that would execute that procedure in a certain night time?

Thanks for any advise.
Jana

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 04:20:19 CST