Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ccaporaso
Partner - Contributor III
Partner - Contributor III

Problem with supporting task and a .bat file

I need to reload a .qvw file permanently between a time range (from 08:00 AM to 08:00 PM). In order to do so, I've created this solution:

 

1) Define a task (let's call A) with "on External program" (On EDX) kind of trigger.

 

2) Define a supporting task (let's call B) that executes a .bat file and it is triggered on success of task A.

 

3) That .bat file calls again task A, previously checking if it is OK to launch the task due to time restrictions.

 

And tested:

 

  1. I manually ran task A,
  2. After A finished, task B was launched,
  3. A was once again triggered (automatically, by the .bat)
  4. By the time A ended (its second execution), B was still running, so it was not invoked and the cycle stopped.

       

In fact, execution time for A was 1 second, and execution time for B was more than a minute. I attach both log files.

 

¿Is there any limitation with .bat files and supporting tasks? ¿Any ideas?

 

Regards,

Cecilia.

3 Replies
patricio
Contributor III
Contributor III

Is it possible for you to run just a normal task and configure the trigger "hourly" to run "every 1 minute". You can also set the trigger to run only between 8 am and 8 pm. This is normal functionality for qlikview tasks.

ccaporaso
Partner - Contributor III
Partner - Contributor III
Author

Hi Patricio!

Thanks for your answer. A one minute interval is not posible for my application (a call center wallboard). I need to reload again as soon as the previous reload finishes in order to be as real time as possible.

Regards,

Cecilia.

preminqlik
Specialist II
Specialist II

hi,

hope this alternate soln works with u,

u can do this by task scheduler in production server,

before that make sure that qlikview desktop is installed in server

then

create a batch file as i attached here

then go to task scheduler in windows

Untitled1.png

action  tab u can give ur application path..

i think u'll get error of licence please lease from qv server..before running bat file...