apx class save error - schedulable class has jobs pending or in progress [duplicate]

Question

I have a scheduled class which in turn calls a Database.executeBatch to start a batch class. I am trying to make some edits to batch class and I am receiving well known "schedulable class has jobs pending or in progress" error message when saving batch class. Based on below article, https://help.salesforce.com/HTViewSolution?id=000004423&language=en_US

I have

1. deleted all scheduled jobs that are under Setup -> Monitoring -> scheduled jobs
2. Also made sure that there are no jobs in queued status

.

SELECT ApexClassId, CreatedDate, ExtendedStatus, Id, JobItemsProcessed, JobType, MethodName, ParentJobId, Status, TotalJobItems 
FROM AsyncApexJob 
WHERE status!='Completed' AND status!='Aborted' AND status != 'Failed'

Above query is returning count as 0.

I have only 1 entry in CronTrigger table where State is "ACQUIRED" and CronJobDetail.Name is null. I tried to call abortjob on this entry but I get an error - Invalid parameter value "000000000000000" for parameter "id") when I run abortjob.

Any idea if this Crontrigger entry is preventing edits to batch class ?

Answer 1

Yes, the entry can prevent you from editing the class.

This is known issue and there's workaround described by Dan Appleman in the following webinar: Design Patterns for Asynchronous Apex. There's a link to the code containing the pattern that prevents this from happening at http://advancedapex.com/dreamforce13/.