Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to invoke a stored procedures every hour? How to Cron ?

56752Aug 29 2002
Hi. I have written a stored procedure using PL/SQL and it needs to invoke every hour to reset certain value. My question is how to cron or to invoke the store procedure every hour? I'm using Oracle 9i database.

Please advice if anyone of you had came acrossed this scenario.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2002
Added on Aug 29 2002
5 comments
3,061 views