Removing External Events for an Old Autosys Instance

Document ID : KB000074502
Last Modified Date : 22/03/2018
Show Technical Document Details
Issue:
We completed our r11.0 to r11.3.6 migration. The old r11 instances were stopped and the machines have been decommissioned. Jobs in r11.3.6 have been updated so they do not contain cross-instance dependencies. The cross-instance configuration has also been updated so there are no references to the old r11 instances. We are still seeing events that are trying to be sent to the old instances. How can we clean this up?

Examples: 
[01/23/2018 12:41:55.0991] CAUAJM_I_40256 [Sending event <OLD0229cvf00>: CHANGE_STATUS to SUCCESS for Job: AUTOSYS_JOB_1136 to external instance <OLD>]
[01/23/2018 12:41:55.0994] CAUAJM_E_10002 Unable to retrieve connection information for instance <OLD>.
[01/23/2018 12:41:55.0997] CAUAJM_E_40257 External instance <OLD> is invalid or unreachable over the network.
[01/23/2018 13:00:01.7786] CAUAJM_I_40256 [Sending event <OLD0229jar00>: CHANGE_STATUS to RUNNING for Job: AUTOSYS_JOB_1136_2 to external instance <OLD>]
[01/23/2018 13:00:01.7788] CAUAJM_E_10002 Unable to retrieve connection information for instance <OLD>.
[01/23/2018 13:00:01.7792] CAUAJM_E_40257 External instance <OLD> is invalid or unreachable over the network.
Environment:
CA Workload Automation AE r11.3.6+
Resolution:
1. Run the following query: select count(*) from AEDBADMIN.ujo_req_job where req_autoserv = 'OLD';
2. If the above query results in one or more rows being returned, run the following query: DELETE from AEDBADMIN.ujo_req_job where req_autoserv='OLD';

* OLD represents  Autosys cross-instance dependency you no longer want to reference.