dbms_scheduler

[TheEntertainer]

Dear All,

I'm trying to create the following job using dbms_scheduler

begin
dbms_scheduler.create_job(
job_name => 'DEMO_JOB_SCHEDULE'
job_type => 'PLSQL_BLOCK'
job_action => 'declare x varchar2(1); begin  select * into x from dual; dbms_output.put_line(x);  end;'
start_date => '08/08/2006 10:50 AM'
repeat_interval => 'FREQ=DAILY'
enabled => TRUE
comments => 'Demo for job schedule.');
end;

I can't see anything wrong but it keeps giving the following error message:

ERROR at line 1:
ORA-01843: not a valid month
ORA-06512: at line 2

I can't figure out why it would be giving that error. Database information below:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Thanks in Advance

 

[KenCunningham]

Perhaps:

http://www.cryer.co.uk/brian/oracle/ORA01843.htm

might help.

All I ask of you
Is make my wildest dreams come true

 

[TheEntertainer]

Thanks for the reply Ken,

I figured it out, by having a look at some of the system dbms_scheduler jobs set up, you've got to enter the date for the start date as '08-AUG-06 11.15.00.000000000' I'm hoping that this equates to 11.15 am if not back to the drawing board.

Once I get it working I think I'll be pretty impressed with the increase capabilities of dbms_scheduler

thanks