Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vmsistemi
New Contributor III

Scheduling times on different days of reload QlikView Server 11.20 SR13

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.

1 Solution

Accepted Solutions

Re: Scheduling times on different days of reload QlikView Server 11.20 SR13

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

4 Replies
mohamed_ahid
Contributor III

Re: Scheduling times on different days of reload QlikView Server 11.20 SR13

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 .

Re: Scheduling times on different days of reload QlikView Server 11.20 SR13

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

MVP
MVP

Re: Scheduling times on different days of reload QlikView Server 11.20 SR13

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
New Contributor

Re: Scheduling times on different days of reload QlikView Server 11.20 SR13

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!

2016-02-12 09_49_03-Eigenschaften des Dokuments [Ziuz Auswertung].png

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.

Community Browser