Hi There, i have been trying to set up a job to run through dbms_scheduler fpr the first time. Everything appears to load in ok but when i check dba_scheduler_jobs the date looks like scheduled for 2020 rather than 2009
Note this is just a test to get working, i am not actually only going to run this once on a friday, just need to see it work first before tailoring.
I have had this set and the time comes and goes and nothing happens. I go to check dba_scheduler_jobs and it tells me that the start date is the following
08-MAY-20 09.12.00.000000 +01:00
That looks like 2020 to me
if i try creating the schedule with dates in format
start_date => '08/MAY/09 12:00:00'
start_date => '2009/MAY/08 12:00:00'
i get errors about date too short or invalid month
I just want to check i am not barking up the wrong tree, that does say 2020 yeah? What do i do to fix this?
I have read i could set NLS_DATE_FORMAT but this could interfere with other things (other peoples scripts?)
Anyone have any suggestions?
Thanks in advance.
ps this is Oracle 10.2.0.1 on Solaris 10