orphaned applications and jobs in database after cold start

Products

• CA Workload Automation DE

Issue/Introduction

After clearing active applications and purgehomelessjobaetdata there are still jobs in the esp_generic_job where there the end_date_time is NULL and the state is not in a finished state (failed,complete, suberror).

Environment

Release : 12.2

Component : CA WORKLOAD AUTOMATION DE (DSERIES)

Resolution

In Desktop Client:

• Navigate to Admin Perspective
• Right Click on the Primary Server and choose "Configure Instance Parameters" 
• Expand Internal and click on the Show Advanced icon
• Scroll down and locate the configuration item called "Remove incomplete applications history at cold start."
• Toggle the value to "true."
  
• Once you've done all of the above, shutdown DE and perform cold start. This should clear out all of the inactive applications that you are concerned about.