var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: proc running time...
Hi guys (Oracle 9i)
I'm running a procedure every hour by specifying the time setting as
Now when the proc runs (for approx 6 sec), the next_run_date in my application gets set to an hour later + the 6 seconds it took the proc to run.
Is there any other way of specifiying sysdate+(1/24) so that those 6 secs are not taken into account when moving the next_run_date 1hr forward?
You could set it to:
Then it will always run "on the minute". Or 'HH' instead of 'MI' to run on the hour.
trunc(sysdate,'MI') + 1/24
Thanks so much