topic Re: Update in the Data BAse in QlikView

Update in the Data BAse

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Update in the Data BAse

dplr-rn — Fri, 20 Mar 2020 16:09:46 GMT

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

Re: Update in the Data BAse

smilingjohn — Fri, 20 Mar 2020 16:51:57 GMT

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

Re: Update in the Data BAse

dplr-rn — Fri, 20 Mar 2020 17:06:00 GMT

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

Re: Update in the Data BAse

Brett_Bleess — Tue, 14 Apr 2020 19:41:58 GMT

You could also use the Continuously trigger in Publisher:

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

See the following link for the Reload Engine equivalent:

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

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