Changeset 33860 for trunk/ippTools/share/pstamptool_revertreq_deletejobs.sql

Timestamp:

May 14, 2012, 1:05:06 PM (14 years ago)

Author:

bills

Message:

Only delete jobs for pstampRequests in new state where the request has faulted.

File:

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

trunk/ippTools/share/pstamptool_revertreq_deletejobs.sql

@@ -3 +3 @@
 FROM pstampJob
     JOIN pstampRequest USING(req_id)
-WHERE pstampRequest.state = 'new'
+WHERE pstampRequest.state = 'new' 
+    AND pstampRequest.fault > 0