I have a client with CMOD on Windows using a remote Clustered SQL Server. For non-Prod environments, it is not unusual for the SQL server to be restarted without warning. Whenever this happens, the CMOD service stops working and requires a restart. CMOD is unusual in that if the DB connection breaks the process shuts down, rather than managing it with an error at login time - until the DB is available again. Has anyone devised a clever way to monitor for this occurrence and automatically restart using OOTB Windows capabilities, without requiring a purchased 3rd party monitoring tool that leverages SNMP alerts or something like that which would be overkill?
Thank you for any feedback.