View the current status of each active job

Owned by Conor McCann
Last updated: May 18, 2018

From the SSMS open a new query from the systems iQSonarSE database


SELECT * FROM jOBS.t_Queue, Note the JobStatusID is set to -3

Run the following sql to update the JobStatusID to Served/Complete
UPDATE  jOBS.t_Queue SET JobStatusID = 1

once complete you will recieve SQL message confirming the amount of the rows affected

You will now be able to rescan the targets of an active project or set up a new Project and scan new targets.