IMPORTANT: It is recommended to have a database backup before performing any steps documented below.

Option 1: Clear All Jobs From the Queue

Use this option to terminate all active, waiting, or scheduled jobs.

NOTE: Before you begin, note that although these actions can be performed while Tomcat is running, shutting down Tomcat is strongly recommended to avoid unintended behavior.

MySQL

1. Shut down Tomcat.
2. Run the following queries:

   UPDATE PSE_SCHEDULER_QUEUES
   SET ACTIVE_TASK_ID_ = NULL;
   
   UPDATE PSE_SCHEDULER_TASKS 
   SET STATE_ = 'TERMINATED' 
   WHERE STATE_ IN (
     'ACTIVE',
     'WAITING_ON_UPDATE',
     'WAITING_ON_LIBRARY_REFRESH',
     'SCHEDULED'
   );

3. Start Tomcat.

Microsoft SQL Server

1. Shut down Tomcat.
2. Run the following queries:

   UPDATE PSE_SCHEDULER_QUEUES
   SET [ACTIVE_TASK_ID_] = NULL;
   
   UPDATE PSE_SCHEDULER_TASKS 
   SET [STATE_] = 'TERMINATED' 
   WHERE [STATE_] IN (
     'ACTIVE',
     'WAITING_ON_UPDATE',
     'WAITING_ON_LIBRARY_REFRESH',
     'SCHEDULED'
   );
   

3. Start Tomcat.

Option 2: Clear a Specific Job From the Queue

Use this option when only one job (for example, a specific scan job) needs to be cleared.

Step 1: Find the Job ID

1. In the Code Insight UI, open the menu from the top-right corner (hamburger icon).
2. Select Jobs.
3. Note the Job ID for the scan you want to remove.
   
   

   Job ID Shown in the Jobs Page

Step 2: Remove the Specific Job

Replace "Job ID" in the queries below with the actual job ID you noted.

MySQL

1. Shut down Tomcat.
2. Run the following queries:

   UPDATE PSE_SCHEDULER_QUEUES
   SET ACTIVE_TASK_ID_ = NULL 
   WHERE ACTIVE_TASK_ID_ = "Job ID";
   
   UPDATE PSE_SCHEDULER_TASKS 
   SET STATE_ = 'TERMINATED' 
   WHERE ID_ = "Job ID";

3. Start Tomcat.

Microsoft SQL Server

1. Shut down Tomcat.
2. Run the following queries:

   UPDATE PSE_SCHEDULER_QUEUES
   SET [ACTIVE_TASK_ID_] = NULL 
   WHERE [ACTIVE_TASK_ID_] = "Job ID";
   
   UPDATE PSE_SCHEDULER_TASKS 
   SET [STATE_] = 'TERMINATED' 
   WHERE ID_ = "Job ID";
   

3. Start Tomcat.

After completing these steps, the selected job or jobs are removed from the job queue. The Jobs page should no longer show the terminated jobs, and other jobs should be able to run normally.