Date format error while schedule a job!
Dear all,
I am using 11gR1 on Linux OS.
I have to schedule a procedure that runs in mid night after 12:00 using dbms_scheduler.
This is the code i am writing:
begin
dbms_scheduler.create_job(
job_name => 'ATT_LATE_MIS_PRC_JOB'
,job_type => 'PLSQL_BLOCK'
,job_action => 'begin att_late_mis(1); end; '
,start_date => '16/10/2009 12:05 AM'
,repeat_interval => 'FREQ=DAILY'
,enabled => TRUE
,comments => 'Attendance MIS');
end;
/
and this is the error i am getting:
ORA-01843: not a valid month
ORA-06512: at line 2
I don't know how to format date for this procedure. All i need to do is to simply schedule a procedure that runs at 12:05 daily.
Thanks, Imran