I set up a scheduled job in Toad to start running at a specific time and then set the subsequent execution to run every day from then on. I used TRUNC(SYSDATE + 1) as the syntax for running the subsequent executions.
TRUNC(SYSDATE + 1) is actually the next day starting at midnight.
Use the following format to run at a specific hour:
TRUNC(SYSDATE+1)+h/24 where h=hour e.g. TRUNC(SYSDATE+1)+6/24 run at 6am
Use the following format to run at a specific hour and minute
TRUNC(SYSDATE + 1) + h/24 + m/1440 where h-hour and m=minute e.g. TRUNC(SYSDATE + 1) + 8/24 + 30/1440 run at 8:30am
