Scheduling a qvw reload soon after database is updated
I have a database (Mysql) in AWS where the data analysts update the data soon after their data cleaning process and intimate me so that I can create the qvds and then after I load the qvd data into a template.
My ask is , is there a way that we can automate this process, such that,
1. Soon after the database is updated the qvd extractor should be executed(reloaded)
2. Soon after the qvd extractor reloading is completed my another file should be reloaded.
Re: Scheduling a qvw reload soon after database is updated
If the cleaning process signalled its completion by dropping a flag file or updating a database table, you could write a batch file that polls for the dropped file or the database table value, and trigger the qvd and application reloads. Set this to run on a scheduled of (for example) every 15 minutes.
This is easier to implement if you have access to an enterprise scheduling tool, or find a suitable freeware or inexpensive scheduling tool that supports this sort of dependency. We do something very like this using AutoSys or Tivoli TWS, but these are enterprise class tools.
The batch file should trigger the qvd reload via EDX (search EDX / QMSEDX on this site for more on how to do this) and then the application reload task can depend on the completion of the QVD reload.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein