Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Update in the Data BAse

Hi All, 

I have a MySQL DB which is connected to the QlikView app and I have scheduled a task every one hour . 

I need to know is there a way to reload the application if any changes takes pkeace in the DB ? 

Or can we schedule a  tasl every 5 mints ?

 

Thanks in Advacne 

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

in the hourly trigger make run every

 hour 0  and minutes 5.

 

But as i said make sure the minutes is higher that the time taken for your reload task to run

View solution in original post

4 Replies
dilipranjith
Partner
Partner

you can schedule a reload every 5 minutes. (if your reload process takes less that 5 mins)

smilingjohn
Creator III
Creator III
Author

Hi Dilipranjith 

How do i do that ? In the task we have option every hour , then how can i schedule it every 5 mints can you please suggest me on this 

dilipranjith
Partner
Partner

in the hourly trigger make run every

 hour 0  and minutes 5.

 

But as i said make sure the minutes is higher that the time taken for your reload task to run

View solution in original post

Brett_Bleess
Support (Former)
Support (Former)

You could also use the Continuously trigger in Publisher:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/QMC/Content/QV_QMC/QMC_Documents_SourceDoc...

See the following link for the Reload Engine equivalent:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/QMC/Content/QV_QMC/QMC_Documents_UserDocum...

One other option, if you do have Publisher and are on 12.30 or later, you could use the new File Exists trigger too if the DB could write out a file when there is an update to it, you just need to be sure you delete the file after the trigger is fired and the task runs to reset things...  This should cover all the options.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.