Fix SugarCRM Job Hung in Running State

If you use SugarCRM and you find a scheduled job that has been stuck in the running state for more than an hour, the job may be hung. I’ve seen this happen when MySQL is restarted or crashed due to memory restrictions.

First, search for the job in the database using this line of SQL:

SELECT * FROM sugarcrm.job_queue WHERE status != 'done';

Then set the job as completed:

UPDATE sugarcrm.job_queue SET status = 'done', resolution = 'success' WHERE id = '[id goes here]' LIMIT 1;

SugarCRM is a flexible, customer relationship management (CRM) software built in PHP. It features a module builder with drag and drop support. There is free version with plenty of great features and modules.