search cancel

SQL Agent only ever trying to connect to one CP, does nothing during CP freeze

book

Article ID: 189355

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

SQL Agent is configured to use CP . What happens if the CP is stuck ? Will the SQL Agent try to 
connect next available CP ? 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Yes , SQL agent will try to connect next available CP if actual connected CP was not stuck with query of something else 
prevented it from closing the communication between agent and CP.