Microsoft SQLServer listener multi-subnet database configuration for Autosys
Environment
AutoSys Workload Automation
Resolution
AutoSys supports 2 HA modes for the database DUAL event server mode or Cluster mode on the database
Best practice for AutoSys is to use the Cluster mode on the database as DUEL event server mode requires a manual process to fail back to the primary database
AutoSys is NOT DB Cluster aware so can not be set up with a MS SQL Server listener multi-subnet database configuration
AutoSys either uses a JDBC connection or native MS Client tools (ODBC Driver) to connect to the database depending on the operating system
A Virtual IP (VIP) for the Cluster can be used ,as the application sees the cluster as a standalone instance of the database
All failover operations happen at the cluster level and the application is unaware of the process.