Reload one script statement only once in a day

[vishsaggi]

I have a requirement where i have three script tabs in a qvw document. Like Script1, Script2, Script3 tabs.

I have this qvw scheduled thrice in a day on QMC. I want Script1 tab which has some Load Statements to run only once. Like Reloading only once. For eg: If the schedule trigger on QMC is @9AM, 12PM and @3PM, the Script1 tab should be reloaded only at 9AM it should not be reloaded @ other trigger times.

Any help much appreciated.

Many thnanks,
V.

[rwunderlich · Accepted solution]

You can wrap the script on  tab1 in a conditional that executes only once per day. For example:

IF frac(now(1)) < MakeTime(11) THEN

  the script

ENDIF

[vishsaggi]

Thanks Rob, will try and get back soon.

[qliksus]

Just put the load statement you want to restrict inside a include file  and put a condition on top of that

IF time()< 12 then

$(Include=9PMload.txt);

end if

And the remaining load statement after this line

[vishsaggi]

Thanks Rob it worked.

[vishsaggi]

Thanks Susant,

I will try that too. I am sure it works too.

[vishsaggi]

I am trying to mark some responses helpful, but this goes forever when i click on Actions link. Did any one faced the same?

[qliksus]

Try after sometime

[vishsaggi]

Nope i have been facing this since yesterday, don't know why.

[rwunderlich]

Yes, I had the problem in Chrome for several days. It worked in Edge browser.  Yesterday it started working in Chrome again. Don't know what the issue is.

-Rob