do you also have the QV_Publisher or only QlikViewServer?
=> If you do not have the Publisher, you can only choose an interval the multiple of which is 24 (hours). You can only schedule a qvw for reload once a day or in regular intervals, but the multiple of those intervals must be 24, else your reload_times will shift every day which you probably don't want.
Thus you can reload every 6hrs, 4hrs, 2hrs ... anything that will fit in 24 without remainder.
If you do have the Publisher, it is easier, but I wouldn't know, we don't have it.
Best regards,
DataNibbler
P.S.: You might have guessed - 7:30 am and 12:30 pm is not possible unfortunately - that would be a 5hr-interval, that doesn't come round to 24.
for me the interval of hours in not match in my case, only two times a day is enough.
for first morning 7.30 i have schedule in the QlikView server and second afternoon 12.30 reload i have plan for Batch reload but the QVW file has section access.
how to give section access file in batch reload automatically?
Hi, you can also schedule every hour your refresh and test in the first steps of your script the current time (with now()), if it not the expected one you call an EXIT SCRIPT else you continue.
that is a brillant idea. We never thought of this. It is logical.
We have a reporting_tool to automatically send pdf or xls_reports via email to certain persons. That is triggered by a scheduled Windows_task running on the server - but we couldn't set that to run every 2hrs, only every hour which is more often than we need.
How to do reload section access qlikview file automatically using Batch reload(Windows task scheduler).
when i tried using batch, command prompt windows starts but it is waiting for QlikView section access username and password. once we entered username and password then only it starts reloading instead of that how to make that automatically it pick section access username and password.
This section access defines two users with the QV authentication USER1 and USER2 which are filtered in your application on the field SECURITYFILTER and a third user (MYDOMAIN/SPECIALACCOUNT) with the Windows authentication which will be used to launch the scheduled task and will not have to enter any password. Be careful, it means that this user will be able to access to the whole application.
