JDBC, sql server - DS1, DS2, DS3, DS4,DS5
I want to get email notification about any DS failure while establishing connection with sql server database.
What I am looking at it is any power shell script or batch script or any denodo vdp, scheduler mechansim which can check if DS-sqlserver connection is up. As sometimes there could be connection issues like account locked, login failed, db in restricted mode.
So I want to run a process at scheduled intervals which could check DS status and notify in case of failure.