2 Replies Latest reply: May 19, 2015 10:41 AM by federico cal RSS

    Load only one time

      Hi,

       

      I have this situation.

       

      I need load a qlikview document depend of a value of one field in database that tell me if load in Oracle finish or not.

       

      So i ask if it is in "1" then load. but i management console i do.

       

      ON SCHEDULE -- HOURLY

      RUN EVERY 0 HOURS 10 MINUTES.

      RUN ONLY BETWEEN 6:00 AM TO 10:00AM

       

      The problem is after this task (data.task) come (layout task)

       

      if oracle finish at 8:00 it will reload 8:10 8:20 8:30 etc.

      I only need one load for day.

      Thanks

        • Re: Load only one time
          Andrei Kaliahin

          Hi, Federico,

           

          Simply add new variable with last reload date information and check it inside your script.

           

          IF $(vLastReload)<date(today()) THEN

          ..... your script....

               LET vLastReload = date(ReloadTime());

          END IF

           

          Of course document will be called for reloading but nothing will be done on second and afterward calls.

           

          But of course better to use External triggered tasks for these purposes, e.g. Reload after finishing your ETL process.

           

          Regards,

          Andrei