|
|
Hello Erman Arslan,
The below job run every Thursday at 10:00 PM to update data' it working fine.
so i want to change to run twice in each month so please guide me
what value i write on repeat_interval
------------------------------------------------------------------------------
BEGIN
DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'UPDATE_WEEKLY',
job_type => 'STORED_PROCEDURE', --'PLSQL_BLOCK',
job_action => 'procedure_name',
number_of_arguments => 0,
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=WEEKLY;BYDAY=THU;BYHOUR=22;BYMINUTE=0;BYSECOND=0',
end_date => NULL,
enabled => TRUE,
auto_drop => FALSE,
comments => 'This job run every Thursday at 10:00 PM to update data'
);
END;
/
|
Locked
