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
- deleted all scheduled jobs that are under Setup -> Monitoring -> scheduled jobs
- 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 ?