Is it possible to allow a Denodo Scheduler job to start only when the value returned by a query indicates it is ok for the job to start?
The scenario is as follows:
We want to cache a Denodo view. However, before we can start the cache job, we need to first check if the source table has a complete set of records. If the source table has everything, then it is ok for the Denodo cache job to start. Otherwise, the Denodo cache job should retry again in the next 10 minutes. After 4 hours of retry, abandon the attempt to cache.
How do we know if the source table has everything? We check the job status that loads data into the Denodo's source table. So whatever is returned by this check determines whether or not the Denodo cache job should run.