oracle_job

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Reply | Threaded
Open this post in threaded view
|

Re: oracle_job

ErmanArslansOracleBlog
Administrator
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.
Reply | Threaded
Open this post in threaded view
|

Re: oracle_job

Arsalan

Thanks Arslan