Schedule a task to run in particular dates every month and for every hour in QlikView

[vijayit43]

Dear All,

We want to create a Reloading Schedule task hourly on every month from 1st date to 10 date in Qlik view using Qlik view management console.

how to achieve this.

please suggest.  

[sunny_talwar]

One option is to create 24 tasks one for each hour with Monthly setting which would allow you to pick all months and first 10 days.

[vijayit43]

Hi Sunny,
but it's create more no of task. any other option to achieve this.
if yes please suggest.

[sunny_talwar]

I have not tried this and not sure if this will even work or not... but try to create a single hourly task and then within your script have an if statement which checks the day of the month

If Day(Today()) < 11 then

   YourScript

ELSE

   Binary Load of your qvw

ENDIF;

[pradosh_thakur]

Hi Sunny

The else part might not work as binary load should be on first line of the script(correct me please if i am wrong)

We can instead add a partial reload so the data doesn't get lost. Again this is not tried and just an idea

If Day(Today()) < 11 then

   YourScript

ELSE

add load * inline [
dim
1
2
];

ENDIF;

We have to enable partial reload for that task in QMC. I would be keen to know if this works.

[MindaugasBacius]

The Windows Task Scheduler might be another option:

For an Action you need to create simple .cmd file like:

"C:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -r="c:\3.Load\File.qvw"

This works totally fine if you're familiar with Task Scheduler and .cmd files 🙂

[sunny_talwar]

You might be right, but why do you think Binary Load won't work? Just looking for obvious reasons that I don't know about.

[pradosh_thakur]

Qlik help says

"Only one binary statement is allowed in the script and it must be the first statement of the script, even before the SET statements usually located at the beginning of the script."

Because of this i thought binary load may not work. I am not sure how the above condition will behave inside the if statement. Again i would be happy to get corrected in case my understanding is wrong.

[MindaugasBacius]

Your suggestion is absolutely correct.
I looked from a different angle to this type of issue. There is no hidden secrets, just another type of solution.

[sunny_talwar]

Going to give it a shot and see what I find 🙂