Changeset 34762 for trunk/ippTools/share/pstamptool_revertdependent.sql

Timestamp:

Dec 3, 2012, 12:29:00 PM (13 years ago)

Author:

bills

Message:

dont' revert dependents unless there is an running job waiting for it

File:

• trunk/ippTools/share/pstamptool_revertdependent.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_revertdependent.sql

@@ -4 +4 @@
 SET pstampDependent.fault = 0
 -- fault count hook %s
-WHERE pstampDependent.state = 'new'
+WHERE pstampRequest.state ='run'
+    AND pstampJob.state ='run'
+    AND pstampDependent.state = 'new'
     AND (pstampDependent.fault > 0)