Software Delivery job listed in All Software Jobs with state Terminating not deleted

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

A SD job in the All Software List that has been stuck in the terminating state for weeks, even after 
rebooting the server and/or restart CAF.
  
Can these types of failed jobs be deleted by a SQL command? 

Environment

CA Client Automation - All versions

Resolution

Follow the steps in reference article to delete the job Unable to delete old job container. Container stuck in terminating status. Is there a way to delete using SQL query.

* Make sure to have a safe backup of the MDB database before attempting to run any query which updates the data.