Hi guys,
it's the first time I'm handling with jobs. I created one just for testing, It is included in the job table "dba_scheduler_jobs" with state attribute as "scheduled". I think it should run secondly, but it doesn't. Does anybody know why??
I created the job like this (created on 04/22/2009 at 19:30:00 ):
begin
dbms_scheduler.create_job(
job_name => 'INSERT_TABLE',
job_type => 'PLSQL_BLOCK',
job_action => 'begin insert into asn_errorlog (id, log, datum) VALUES (NULL, sadas, sadsad); end;',
number_of_arguments => '0',
start_date => to_date('04/22/2009 19:48:00','mm/dd/yyyy HH24:MI:SS'),
repeat_interval => 'freq=secondly',
end_date => NULL,
job_class => 'DEFAULT_JOB_CLASS',
enabled => TRUE,
auto_drop => FALSE,
comments => NULL);
END;
Thanks for any kind of help!
Patrick