Note: Below steps should be done using a user with admin privileges.

  1. Check BQM job status
    1. Go to PQW Batch Queue Manager.
    2. Verify if jobs are stuck in any status other than Completed or Failed for long period.
  2. Check if BQS is still running
    1. Go to Setup and search for Scheduled Jobs.
    2. Verify the status of the job titled - BatchQueueScheduler.
      1. If the job is not present in list or if the Next Scheduled Run column is blank, then it means it's not running.
      2. If the job is present and the Next Scheduled Run column has correct time then the job is running but it's stuck.
  3. Restart BQS
    1. Go to Configure tab.
    2. Scroll down to StrataVAR Scheduler Manager.
    3. Click Start Batch Scheduler
    4. If the button is greyed out, then click Stop Batch Scheduler then click Start Batch Scheduler to restart it.
  4. Creating jira for dev investigation
    1. If the BQM is still stuck after restarting BQS, the we should escalate it to the dev team for investigation and must share the below details:
      1. Mention in details all the finding from the above steps.
      2. Create an excel file with sql query results from BQM and Apex Jobs using the below queries:

        BQM - SELECT Id,Name, StrataVAR__Batch_Creator__c,StrataVAR__Batch_Job_Class__c,StrataVAR__Status__c,StrataVAR__batchId_SFDC__c,CreatedDate,LastModifiedDate FROM StrataVAR__Batch_Queue_Manager__c where CreatedDate >2025-02-18T00:30:24.000+0000 and CreatedDate <2025-02-18T01:20:24.000+0000 order by CreatedDate asc

        Apex Job - SELECT Id,ApexClass.Name, Status,JobItemsProcessed, TotalJobItems,MethodName, CreatedDate,CompletedDate,CreatedBy.name from AsyncApexJob where CreatedDate >2025-02-18T00:40:44.000+0000 and CreatedDate <2025-02-18T00:50:50.000+0000 order by CreatedDate asc

        Note: The CreatedDate time range should cover the period from the last few successful jobs through the most recent job.