oracle_job

Posted by Arsalan on Feb 17, 2019; 6:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/oracle-job-tp7245.html


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;
/