Oracle Database Discussions

Hi all.

I have a job that I need to run every 5 minutes. However, I need it to run every 5 minutes starting on the hour always. i.e. Runs at 1:00, 1:05, 1:10, etc...

I know I can use start date at :00 of some hour and a repeat interval of minutely and interval of 5, but what will happen when the database is restarted after it is brought down for some maintenance. I don't want it to run every 5 minutes after the first run (until the first run is always guaranteed to start at the top of an hour)

What is the proper way to schedule this top of job ?

Thanks.