--
-- Version : 5.7.4
--
-- File    : xwpilotjoblist.sql
-- Purpose : this file contains the needed SQL commands to 
--           retreive pilot jobs from DB
-- Usage   : mysql < xwpilotjoblist.sql
--


select apps.name,hosts.name,hosts.pilotjob from works,tasks,apps,hosts where works.uid=tasks.uid and tasks.hostuid=hosts.uid and hosts.pilotjob="true";

--
-- End Of File
--
