Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can do this by triggering the application from external program which can sense of DB load complete.
What kind of "DB load"?
go through the below link
Hi,
The trigger is required on SQL Server ETL Load.
Regards,
ARN
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
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.