Index: trunk/ippTools/share/pstamptool_stopdependentjob.sql
===================================================================
--- trunk/ippTools/share/pstamptool_stopdependentjob.sql	(revision 29248)
+++ trunk/ippTools/share/pstamptool_stopdependentjob.sql	(revision 29248)
@@ -0,0 +1,9 @@
+-- stop jobs which have a faulted dependent
+UPDATE pstampDependent
+    JOIN pstampJob USING(dep_id)
+    JOIN pstampRequest USING(req_id)
+SET pstampJob.state = 'stop', 
+    pstampJob.fault = %d,
+    pstampDependent.fault = %d 
+WHERE pstampJob.state = 'run'
+    AND pstampDependent.state = 'new'