Scheduling times on different days of reload QlikView Server 11.20 SR13

[Anonymous]

Goodmorning everyone.
How can I schedule different times on different days of reload QlikView Server 11.20 SR13?
It's possible to exclude the reload for a particular day?
I tried to use but the same time is assigned to every day of the week.
Can you give me some advice please?
Thank you.

[mohamed_ahid]

HI,

I guess you have only qlikview server installed .I'm not sure if you can do that without publisher .Another solution is using bat files to do that .

[marcus_sommer · Accepted solution]

With only a server in use you could only set one single trigger to a task and with the offered options you couldn't get what you want but by using from a publisher it would be possible.

Beside above mentioned batch-reloading you could use a small check within the beginning of the qvw, like:

if match(weekday(today()), 'Sa', 'Su') then

     exit script;

end if

The task itself will run every day but the real script will be only executed on these days which you want (maybe you need some adjustements on the format).

- Marcus

[maxgro]

Check the day and if it's a day to exclude, raise an error  (load * from notexistfile.txt).

You get a red cross error in the QMC console but the .qvw doesn't change.

[umfoeqlik]

Normaly when you open a QVW, you can open the Document Preferences (CTRL + ALT + D). There in the reload tab you can set weekly and then select the days when the qvw should relaod or not, but for me this never worked!

The exit script; command in the script will empty the qvw, so that you can't work with the data at the weekend, also no option. So many thanks to M G for the idea with the relaod fail!

if match(weekday(today()), 'Sa', 'So') then

load * from notexistfile.txt;

end if

Don't forget to change the weekdays to your settings from you script (SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';)

Now I get some fail mails from the puplisher but the data in the qvw will be untouched, and the reload will work from Mo - Fr.