I need to reschedule it so that it run only once a day at 10pm.
1) The syntax to do this is to run DBMS_JOB.Change(...) function only or to run DBMS_JOB.Next_Date follow by DBMS_JOB.Interval?
2) Can I include time in the next_date?
3) Is the job will start the first execution at the first "next_date"?
Does that means that I can submit the changes at anytime, and set the datetime to 10pm and interval to sysdate + 1? Will this really give me the correct timing?