I've set up some alerts, based on this article
Now I would like the Job that is triggered by the alert to send some information to a c# application (this application, can be running in the same machine of the SQL instance, and then the C# application sends the information to other machine).
My application can accept TCP connections so I was thinking about using that, but any other form for the SQL server to communicate with my application is also welcome.
Any suggestions in how I can do this?
*edit:*Being able to do an insert in another database(in other instance) via T-SQL would also solve my problem.
Background info: I'm doing this to monitor when the Principal server is running exposed, and when the Mirror server is synchronized. So that if the witness goes down, and then the principal also goes down, based on the records of these alerts I can tell if its safe to promote the Mirror to Principal.
Note, that in this case scenario I cant read the mirror database without break the mirroring configuration, so using a table inside the Mirrored database is not a solution.