Cannot find CONN.SQL objects used in JOBS.SQL objects.
Article ID: 87548
CA Automic Workload Automation - Automation Engine
Error Message : N/A
The "Search for use" function on a connection object does not work correctly. When this function is applied to an object of the type CONN.SQL, which is set as the connection object of a JOBS.SQL object, the job object is not found. As a consequence, the “Replace” function doesn’t work correctly for CONN.SQL objects.
This can easily be reproduced by following these steps: 1. Create a SQL CONN object, create an SQL job that uses that SQL CONN object. 2. Use the "Search for use" function for that SQL CONN object and it will not be found and displayed.
The "Search for use" function should show the results of the SQL jobs which use the SQL CONN object. This has been fixed and released in the versions listed below.
Cause type: Defect Root Cause: Refer to description