dbms_scheduler time problem

[philthee]

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.

begin
dbms_scheduler.create_schedule(
   schedule_name => 'phil_schedule'
  ,start_date => '08/MAY/2009 12:00:00'
  ,repeat_interval => 'FREQ=WEEKLY'
  , comments => 'Weekly on Fri at 12');
END;
/ 

begin
   dbms_scheduler.create_job
   (
      job_name      => 'ifstest_statspack',
      schedule_name => 'phil_schedule',
      job_type      => 'EXECUTABLE',
      job_action    => '/home/oracle/statspack/scripts/ifstest-statspack.sh',
      enabled       => true,
      comments      => 'Run shell-script'
   );
end;
/

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'
or
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

P

[LKBrwn_DBA]

Try:

-- Etc --
 ,start_date => TO_DATE('08/MAY/2009 12:00:00','DD/MM/YYYY HH24:MI:SS')
-- Etc --

PS: Not sure if you need outer single or double or no quotes.

[philthee]

Try:

-- Etc --
 ,start_date => TO_DATE('08/MAY/2009 12:00:00','DD/MM/YYYY HH24:MI:SS')
-- Etc --

PS: Not sure if you need outer single or double or no quotes.

Thanks, that worked just as you wrote it.