Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aparnanair1405
Contributor II
Contributor II

Application reload trigger.


Hi  Community,

We have a DB server and an application server (2 different server IPs).

I need to trigger the application reload whenever the db load is complete.

Any help is appreciated.

Regards,

ARN.

Labels (1)
6 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

You can do this by triggering the application from external program which can sense of DB load complete.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

What kind of "DB load"?

manojkulkarni
Partner - Specialist II
Partner - Specialist II

go through the below link

Using EDX in QlikView 11 - basic example

aparnanair1405
Contributor II
Contributor II
Author

Hi,

The trigger is required on SQL Server ETL Load.

Regards,

ARN

Peter_Cammaert
Partner - Champion III
Partner - Champion III

If I'm not mistaken, a SQL Agent batch job can launch a command line program at the end of a succesful execution. Use QMSEDX as command line tool that allows you to trigger a task in the QMC from any machine in your network.

See Manoj K's link below for more information.

Best,

Peter

petter
Partner - Champion III
Partner - Champion III

You could also just have a check of a status flag in a status table in your database that is done in the beginning of your load script to see if it is time for a reload. You could then have this load script to poll every 5 minutes or so - but only do the reload work when the status flag says so.