For the fine status it depends on the type. For Xacute, XML, ... it's automatically Running when it's enabled. For SQL, the status is recovered from the Validation Query. I think MII dynamically displays the status depending on the type.
The Illuminator services get data from MII database so no "executing" information.
I don't know why you need this information but you can by example create some test queries to check the connection.
I want to have some kind of monitoring of data connectors status. When any of the data connector status is stopped , it should give me a notification (email). So using this service , I want to schedule a transaction which check the status of all the connectors on that MII server.
Most of the times, we are not aware when MII lost connections to any sql or oracle in time. we have lot of MII servers and lot of sql servers,oracle servers. we will come to know only when the end users raised the tickets for not getting the data in the applications.
I am not sure whether I can have monitoring of sqlservers,oracles from MII side. Can you please suggest the better way to handle this.
Loop on this list and call passing Server as parameters and by type (JDBC driver by example) and call correct SQL Query. If Success is true and SYSDATE is filled, it means that the data server is up.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.