asked on
Oracle Scheduler times
In Oracle Scheduler does trunc(sysdate +1) +2/24 mean tomorrow at 2:00 AM?
Oracle Database
Last Comment
Jblue R
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you --
No problem.
I was adding to my post when you accepted this, so make sure you see the additional information I posted.
I was adding to my post when you accepted this, so make sure you see the additional information I posted.
ASKER
Thank you -- Actually, it is a refresh NEXT clause on an Oracle MV..
You can always create you own MV scheduler instead of letting Oracle do it for you.
ASKER
Roger -- this was created eons ago, just anted to check the timing of NEXT.. is working fine..
Thank you
Thank you