Changeset 35410 for trunk/ippTools/share/pstamptool_completedreq.sql

Timestamp:

Apr 17, 2013, 3:04:00 PM (13 years ago)

Author:

bills

Message:

don't count jobs in state 'cancel' as 'running' so that a job
is finished if all jobs are in state stop or cancel

File:

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

trunk/ippTools/share/pstamptool_completedreq.sql

@@ -8 +8 @@
         SELECT count(*) FROM pstampJob 
         WHERE pstampJob.req_id = pstampRequest.req_id
-                AND pstampJob.state != 'stop'
+                AND pstampJob.state != 'stop' 
+                AND pstampJob.state != 'cancel'
         ) = 0