1
2
3
4
5
Apex script unhandled exception by user/organization: xxxx_user_id/xxxx_org_id

Scheduled job 'xxxxxx_schedule_class' threw unhandled exception.

caused by: System.AsyncException: You've exceeded the limit of 100 jobs in the flex queue for org xxxx_org_id. Wait for some of your batch jobs to finish before adding more. To monitor and reorder jobs, use the Apex Flex Queue page in Setup.

1
Integer flexQueueSize = [SELECT COUNT() FROM AsyncApexJob WHERE Status = 'Holding' FOR UPDATE];

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
List<AsyncApexJob> jobs = [SELECT 
    Id,
    CreatedDate,
    CreatedById,
    JobType,
    ApexClassId,
    Status,
    JobItemsProcessed,
    TotalJobItems,
    NumberOfErrors,
    CompletedDate,
    MethodName,
    ExtendedStatus,
    ParentJobId,
    LastProcessed,
    LastProcessedOffset
 FROM AsyncApexJob
where ApexClass.name= 'bacth class name'
and Status = 'Holding'];
for(AsyncApexJob job : jobs){
    System.debug('stop job : ' + job.id + ', ApexClassId= ' + job.ApexClassId);
    System.abortJob(job.id);
}