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?
Oracle Database

Avatar of undefined
Last Comment
Jblue R

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jblue R

ASKER
Thank you --
slightwv (䄆 Netminder)

No problem.

I was adding to my post when you accepted this, so make sure you see the additional information I posted.
Jblue R

ASKER
Thank you -- Actually, it is a refresh NEXT clause on an Oracle MV..
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
slightwv (䄆 Netminder)

You can always create you own MV scheduler instead of letting Oracle do it for you.
Jblue R

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

Thank you