Last Modified Date Trigger in QMC

[Anonymous]

Hi All,

Can we create a task in QMC, which will get triggered, whenever the data gets updated in database.

Please provide your inputs.

Thanks & Regards,

MK

[adamdavi3s]

There is quite a good doc on here which *might* be useful but it depends what you can do database side really:

https://community.qlik.com/docs/DOC-9221

A "Qlik" Way of doing it is to have a very simple qvw scan for changes, let it fail the reload if there aren't any, and then schedule your main app to run if this one is successful.

No new data- reload fail - main app doesn't reload

new data- reload works- main app reloads

[Peter_Cammaert]

Most database systems provide a mechanism to trigger (external) actions whenever a certain event (change, condition, etc.) occurs. For example, in SQL Server, you have the SQL Server Agent that monitor the DB and acts upon configurable conditions.

If your DBMS supports such a mechanism, it is very easy to make the Database run QMSEDX Enhanced to trigger a task in QMC. The big advantage of this method vs. polling or looping is that no cpu cycles are wasted by monitoring processes or remaining in a wait.loop to consistently check whether a condition has been fulfilled. Something only happens when it needs to happen. Not before, not afterwards.

Best,

Peter

[Anonymous]

Thanks for the replies...

The reson I need to Reload the application is, when I trie direct discovery, BUNDLE INFO load was not working