Dear all,
i am using oracle 10g R2 on windows 64 bits.
i have the following code to run an executeable after every 5 minutes everyday except FRIDAY and SATUREDAY.
it is executing a bat file. if i double click the bat file, it is working fine. but the scheduler is not executing it.
begin
dbms_scheduler.create_schedule(
schedule_name => 'populate_free_pc_5_mint',
repeat_interval => 'FREQ=MINUTELY; INTERVAL=5;
BYDAY=TUE,WED,THU,SUN,MON;' ,
comments => 'schedule to run daily after 5 minutes');
dbms_scheduler.create_program
( program_name => 'Populate_Free_PC',
program_type => 'EXECUTABLE',
program_action => 'F:\free_access_lab\execute.bat >
nul',
enabled => TRUE,
comments => 'Populate the free_pc table'
);
dbms_scheduler.create_job (
job_name=>'refresh_free_pc',
program_name =>'Populate_Free_PC',
schedule_name=> 'populate_free_pc_5_mint',
enabled => true,
comments => 'populate the free_pc table after each 5 minutes'
);
end;
could somebody guide me what is the problem?
thank you.