Page Comparison

Problem

Clearing all queue Jobs

Solution

Follow these steps to clear all queued scanning jobs :

• Stop all running services
• execute the following SQL on your production DB.

DELETE FROM FoundDeviceActiveJob;

DELETE FROM DeviceActiveJob;

UPDATE FoundDeviceScanHistory
SET Nextscandate = NULL;

UPDATE DeviceScanHistory
SET Nextscandate = NULL;

DELETE FROM FoundApplicationActiveJob;

DELETE FROM ApplicationActiveJob;

UPDATE FoundApplicationScanHistory
SET Nextscandate = NULL;

UPDATE ApplicationScanHistory
SET Nextscandate = NULL;

Related articles