Hellow All,
We have
oracle 10g On windows....
i have created a schedular like below
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'TEST_JOB',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN DDD; END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=MINUTELY; byminute=0; bysecond=0;',
end_date => NULL,
enabled => TRUE,
comments => 'Job defined entirely by the CREATE JOB procedure.');
END;
could you please tell me what is the repeat_interval of above. I have specified MINUTELY but it's not firing after each minute.