Index: trunk/ippTools/share/pstamptool_pendingjob.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingjob.sql	(revision 25127)
+++ trunk/ippTools/share/pstamptool_pendingjob.sql	(revision 25199)
@@ -1,4 +1,7 @@
-SELECT *
- FROM pstampJob
- WHERE state = 'run'
-    AND fault = 0
+SELECT pstampJob.*
+FROM pstampJob
+    JOIN pstampRequest using(req_id)
+WHERE pstampRequest.state = 'run'
+    AND pstampRequest.fault = 0
+    AND pstampJob.state = 'run'
+    AND pstampJob.fault = 0
Index: trunk/ippTools/share/pstamptool_pendingreq.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingreq.sql	(revision 25127)
+++ trunk/ippTools/share/pstamptool_pendingreq.sql	(revision 25199)
@@ -7,2 +7,3 @@
     USING(ds_id)
  WHERE pstampRequest.state = 'new'
+    AND pstampRequest.fault = 0
Index: trunk/ippTools/share/pstamptool_revertjob.sql
===================================================================
--- trunk/ippTools/share/pstamptool_revertjob.sql	(revision 25199)
+++ trunk/ippTools/share/pstamptool_revertjob.sql	(revision 25199)
@@ -0,0 +1,5 @@
+UPDATE pstampJob 
+    JOIN pstampRequest USING(req_id)
+SET pstampJob.fault = 0
+WHERE  pstampRequest.state = 'run'
+    AND pstampJob.state = 'run'
Index: trunk/ippTools/share/pstamptool_revertreq.sql
===================================================================
--- trunk/ippTools/share/pstamptool_revertreq.sql	(revision 25199)
+++ trunk/ippTools/share/pstamptool_revertreq.sql	(revision 25199)
@@ -0,0 +1,4 @@
+UPDATE pstampRequest
+    SET fault = 0
+WHERE pstampRequest.state != 'stop'
+    
Index: trunk/ippTools/share/pstamptool_revertreq_deletejobs.sql
===================================================================
--- trunk/ippTools/share/pstamptool_revertreq_deletejobs.sql	(revision 25199)
+++ trunk/ippTools/share/pstamptool_revertreq_deletejobs.sql	(revision 25199)
@@ -0,0 +1,5 @@
+-- delete jobs that got added by an incomplete pstamp parser run
+DELETE pstampJob
+FROM pstampJob
+    JOIN pstampRequest USING(req_id)
+WHERE pstampRequest.state = 'new'