oracle_job

[Arsalan]

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

[ErmanArslansOracleBlog]

You will update the  repeat_interval accordingly.

Check https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse004.htm
"Using the Scheduler Calendaring Syntax" section.
There are lots of examples in that section.

[Arsalan]

Thanks Arslan