1 Reply Latest reply: Oct 14, 2010 10:37 AM by Mark McCoid RSS

    Scheduling a job to run only on week days

    Mark McCoid

      I need to schedule a job to run only on the week days. I don't have a publisher license and was hoping there was some way to do it via QVS and not have to resort to a batch file and windows scheduler.

      I've been through all the options in QVS's reload panel and can't figure out any way to do this.

      Has anyone else cracked this nut?

      Thanks for any info!

        • Scheduling a job to run only and week days
          Mark McCoid

          Since it doesn't look like there is native functionality to do this I came up this work around in case anyone else needs to do something like this.

          I created a QVW file called Preloader.QVW which is going to be the scheduled to load every day at 4AM.

          The script for this file is:

           

           


          IF Match(WeekDay(today()), 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') > 0 THEN
          Exit Script;
          ELSE
          LOAD
          X
          Resident IDontExist;
          END IF


           

          My file that I only want to run M-F will be set to load only when the Preloader.QVW file finishes successfully. The file I want to run on Sat, Sun will be set to load only when the Preloader.QVW file fails.

          Hope this helps.