Update in the Data BAse

[smilingjohn]

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 

[dplr-rn]

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

[smilingjohn]

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 

[dplr-rn · Accepted solution]

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

[Brett_Bleess]

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