Autosys support for SQL Server Database failover

Products

• Autosys Workload Automation

Issue/Introduction

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.

Additional Information

WCC - to change the database configuration please use the wcc_config tool

To change the database configuration for the Scheduler and app server