How to cancel or delete a stuck migration job (4322107)

How can a user cancel or delete a migration job that appears to be stuck in the Content Matrix Console? It's either there is no "Cancel" button, the "Delete Jobs" button is grayed out or the "Cannot delete jobs while they are running" warning message is displayed when attempting to delete the job.

Any of the following may be perform:

• Right-click on the migration job, and then select "Run selected job locally". Once the job is running, click the "Cancel" button and it may be deleted from the Jobs List.
• Restart the machine that is running the Content Matrix Console.
• Delete the stuck migration job through CompactView (if the job history is being stored locally) or SQL Server Management Studio (if the job history is being stored in a SQL Server).

  
  CompactView

  1. Close the Content Matrix Console.
  2. Download and install CompactView.
  3. Navigate to %AppData%\Metalogix\Content Matrix Console - SharePoint Edition, select "All files (*.*) and open the JobHistory.lst file.
     
     
      
  4. Use the query below to delete the stuck migration job:

     delete from Jobs
     where JobId = ''