ORACLE DBMS JOB
Posted on 2001-06-26
This is with regards to the DBMS_JOB utility in ORACLE. I need to run a job at 10:00 AM on all days. The problem is that iam not able to specify the exact date as such. I can either set the next date to some currentdate+x number of hours/monutes/seconds. But ia not able to psefcify the exact date.
Let us assume that i need to run a job on
02-jan-2001 10:00AM and my current system date is 01-jan-2001 18:00PM
My DBMS_JOB statement would like :
But say if i run this job at 20:00 Hrs on 01-jan-2001 the next date time will go further to 14:00 Hrs on 02-jan-2001.
How do i specify the exact time ?
Help me out