Link to home
Start Free TrialLog in
Avatar of Jblue R
Jblue R

asked on

Oracle Scheduler times

In Oracle Scheduler  does trunc(sysdate +1) +2/24  mean tomorrow at 2:00 AM?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jblue R
Jblue R

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.
Avatar of Jblue R

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.
Avatar of Jblue R

ASKER

Roger -- this was created eons ago, just anted to check the timing of NEXT..  is working fine..

Thank you