Application reload trigger.

[aparnanair1405]

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.

[manojkulkarni]

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

[Peter_Cammaert]

What kind of "DB load"?

[manojkulkarni]

go through the below link

Using EDX in QlikView 11 - basic example

[aparnanair1405]

Hi,

The trigger is required on SQL Server ETL Load.

Regards,

ARN

[Peter_Cammaert]

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]

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.