SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date and Time issue oracle job

924460Mar 17 2012 — edited Mar 19 2012

i have wriited oracle job to execute my procedure and the job has to execute the procdedure at 11:30 pm every day.

following are the parameters of the JOB.

next_date => TRUNC(SYSDATE) + 23/24+ 0.5/24

interval => 'SYSDATE + 1'

But it is not executing the procedure at 11.30 pm everydat. Waht coud be wrong in the schedule part. please help me in this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2012

Added on Mar 17 2012

5 comments

614 views