2 Replies Latest reply: Nov 14, 2012 7:56 AM by EdStevens RSS

    Scheduler question

    Nuno
      Hello

      I want to run a scheduled job every Monday and Friday (at 00:15).
      Which is right?

      FREQ=DAILY;
      BYDAY=FRI,MON;
      BYHOUR=0;
      BYMINUTE=15

      FREQ=WEEKLY;
      BYDAY=FRI,MON;
      BYHOUR=0;
      BYMINUTE=15


      Thanks for the help
        • 1. Re: Scheduler question
          Osama_Mustafa
          Nuno wrote:
          Hello

          I want to run a scheduled job every Monday and Friday (at 00:15).
          Which is right?

          FREQ=DAILY;
          BYDAY=FRI,MON;
          BYHOUR=0;
          BYMINUTE=15

          FREQ=WEEKLY;
          BYDAY=FRI,MON;
          BYHOUR=0;
          BYMINUTE=15


          Thanks for the help
          *‘freq=weekly; byday=FRI,MON; byhour=0; byminute=15; bysecond=0;’*
          • 2. Re: Scheduler question
            EdStevens
            Nuno wrote:
            Hello

            I want to run a scheduled job every Monday and Friday (at 00:15).
            Which is right?

            FREQ=DAILY;
            BYDAY=FRI,MON;
            BYHOUR=0;
            BYMINUTE=15

            FREQ=WEEKLY;
            BYDAY=FRI,MON;
            BYHOUR=0;
            BYMINUTE=15


            Thanks for the help
            Either will work the same. See http://awads.net/wp/2011/02/02/25-unique-ways-to-schedule-a-job-using-the-oracle-scheduler/