Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Scheduling a job on particular DAY basis

DBQuestNov 8 2018 — edited Nov 8 2018

Hi,

I want to create a job, It should run only on every Sunday and Wednesday at 11:00 AM.

And it should run from 11th Nov Sunday. I have created below script. Please confirm whether its fine OR not ??

begin

  DBMS_SCHEDULER.CREATE_JOB(JOB_NAME        => 'OMS.JOB_INS_MISSING_ORDERS',

                            START_DATE      => TO_DATE('11-NOV-18 11:00','DD-MON-RR HH24:MI'),

                            REPEAT_INTERVAL => 'FREQ=DAILY;BYDAY=SUN,WED',

                            END_DATE        => NULL,

                            JOB_TYPE        => 'STORED_PROCEDURE',

                            JOB_ACTION      => 'OMS.PKG_OMS_ARC_MOVEMENT.PRC_INS_MISSING_ORD',

                            AUTO_DROP       => TRUE,

                            ENABLED         => TRUE,

                            COMMENTS        => 'This job is used to insert missing orders');

end;

/

Thanks
This post has been answered by BrunoVroman on Nov 8 2018
Jump to Answer
Comments
Post Details
Added on Nov 8 2018
3 comments
1,366 views