Sleep command & QlikView engine

[#1]

Hi All,

The QlikView dashbaord that we have built is sourcing data from a data warehouse. The refresh of the data warehouse completes anytime between 6am to 9am. Once the refresh is over it updates a flag in one of the table with the refresh complte date time stamp (initially this falg will be NULL). At time this refresh job may take longer and finish any time after 9am.

The requirement for QlikView is to trigger the QlikView dashbaord refresh as soon as the data warehouse refresh is complete (based on the flag). For this we have built a QVW which has a SLEEP command to keep checking the flag for every 15 mins. Once we find a date in that field, it triggers the main QVW refresh.

This solution is meeting business requirement, but I suspect for this duration (around 4+ hrs), one QlikView engine will be allocated to this (please correct if my understanding is wrong). Thus we are running short of QlikView engines to refresh other dashbaords.

Is there any other alternatives available to meet the desired business requirement?

Regards,

Murali

[Anonymous]

Depending on what database you have it sounds to me like it would be easier to implement a trigger functionality than a pull functionality from the QlikView side.

For example, many databases support creating trigger tasks, like SQL Agent Jobs in SQL Server. Perhaps you could create a trigger in the DB that fires on the completion of the data warehouse refresh and triggers an EDX job on the QlikView side of things?

[#3]

Thanks Johannes.

Its a SQL 2008 database and I think we can try the solution that you have proposed.

I will try the same and update the results here.

Regards,

Murali