Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 23898)
+++ trunk/ippTools/share/Makefile.am	(revision 23912)
@@ -106,9 +106,13 @@
      disttool_pendingcomponent.sql \
      disttool_pendingfileset.sql \
+     disttool_pendingdest.sql \
      disttool_processedcomponent.sql \
+     disttool_queuercrun.sql \
+     disttool_revertrcrun.sql \
      disttool_revertrun_update.sql \
      disttool_revertrun_delete.sql \
      disttool_revertfileset.sql \
      disttool_toadvance.sql \
+     disttool_updatercrun.sql \
      faketool_change_exp_state.sql \
      faketool_change_imfile_data_state.sql \
Index: trunk/ippTools/share/difftool_pendingcleanupskyfile.sql
===================================================================
--- trunk/ippTools/share/difftool_pendingcleanupskyfile.sql	(revision 23898)
+++ trunk/ippTools/share/difftool_pendingcleanupskyfile.sql	(revision 23912)
@@ -10,2 +10,3 @@
 WHERE
     diffRun.state = 'goto_cleaned'
+    AND diffSkyfile.data_state = 'full'
Index: trunk/ippTools/share/disttool_pendingdest.sql
===================================================================
--- trunk/ippTools/share/disttool_pendingdest.sql	(revision 23912)
+++ trunk/ippTools/share/disttool_pendingdest.sql	(revision 23912)
@@ -0,0 +1,12 @@
+SELECT DISTINCT
+    rcDestination.*,
+    count(fs_id) as pending_fs
+FROM rcDestination
+JOIN rcRun using(dest_id)
+WHERE rcRun.state = 'new'
+    AND rcDestination.state = 'enabled'
+    AND status_uri IS NOT NULL
+    -- where hook %s
+GROUP BY dest_id
+HAVING count(fs_id) > 0
+
Index: trunk/ippTools/share/disttool_queuercrun.sql
===================================================================
--- trunk/ippTools/share/disttool_queuercrun.sql	(revision 23912)
+++ trunk/ippTools/share/disttool_queuercrun.sql	(revision 23912)
@@ -0,0 +1,21 @@
+-- create rcRun's for all destinations that have filesets that they are interested in available
+INSERT INTO rcRun
+SELECT                  -- rows in this select must match rcRun
+    0,                  -- rc_id (auto-increment)
+    fs_id,
+    dest_id,
+    'new',
+    NULL,                -- status_fs
+    NULL,                -- registered (database sets this to CURRENT_TIMESTAMP)
+    0                    -- fault
+
+FROM rcDestination 
+JOIN rcInterest USING(dest_id) 
+JOIN distTarget USING(target_id) 
+JOIN rcDSProduct USING(prod_id)
+JOIN distRun USING(target_id, stage) 
+JOIN rcDSFileset USING(prod_id, dist_id)
+LEFT JOIN rcRun using(fs_id, dest_id)
+WHERE rcRun.rc_id IS NULL
+    AND rcDSFileset.state = 'full'
+    AND rcDSFileset.fault = 0
Index: trunk/ippTools/share/disttool_revertrcrun.sql
===================================================================
--- trunk/ippTools/share/disttool_revertrcrun.sql	(revision 23912)
+++ trunk/ippTools/share/disttool_revertrcrun.sql	(revision 23912)
@@ -0,0 +1,3 @@
+UPDATE rcRun SET fault = 0
+WHERE fault != 0
+
Index: trunk/ippTools/share/disttool_updatercrun.sql
===================================================================
--- trunk/ippTools/share/disttool_updatercrun.sql	(revision 23912)
+++ trunk/ippTools/share/disttool_updatercrun.sql	(revision 23912)
@@ -0,0 +1,9 @@
+UPDATE rcRun
+JOIN rcDestination USING(dest_id)
+JOIN rcDSProduct USING(prod_id) 
+JOIN rcDSFileset using(prod_id, fs_id)
+SET
+    -- set hook %s
+WHERE
+    rcRun.state = 'new'
+
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23898)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23912)
@@ -1297,5 +1297,7 @@
     dest_id     BIGINT,
     state       VARCHAR(64),
+    status_fs_name   VARCHAR(64),
     registered  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    fault       SMALLINT DEFAULT 0,
     PRIMARY KEY(rc_id),
     FOREIGN KEY(fs_id) REFERENCES rcDSFileset(fs_id),
Index: trunk/ippTools/share/rcserver_updatercrun.sql
===================================================================
--- trunk/ippTools/share/rcserver_updatercrun.sql	(revision 23912)
+++ trunk/ippTools/share/rcserver_updatercrun.sql	(revision 23912)
@@ -0,0 +1,9 @@
+UPDATE rcRun
+JOIN rcDestination USING(dest_id)
+JOIN rcDSProduct USING(prod_id) 
+JOIN rcDSFileset using(prod_id, fs_id)
+SET
+rcRun.fault= 42, rcDestination.last_fileset = 'o4741g0236o.chip.14519.33.1'
+
+
+