1# 2# For sql_update.c db_update_stats 3# 4INSERT INTO JobHisto ( 5 JobId, Job, Name, Type, Level, ClientId, JobStatus, SchedTime, StartTime, EndTime, RealEndTime, JobTDate, 6 VolSessionId, VolSessionTime, JobFiles, JobBytes, ReadBytes, JobErrors, JobMissingFiles, PoolId, FileSetId, 7 PriorJobId, PurgedFiles, 8 HasBase, Reviewed, Comment 9 ) 10SELECT JobId, Job, Name, Type, Level, ClientId, JobStatus, SchedTime, StartTime, EndTime, RealEndTime, JobTDate, VolSessionId, 11 VolSessionTime, JobFiles, JobBytes, ReadBytes, JobErrors, JobMissingFiles, PoolId, FileSetId, PriorJobId, PurgedFiles, 12 HasBase, 13 Reviewed, Comment 14 FROM Job 15 WHERE JobStatus IN ('T','W','f','A','E') 16 AND NOT EXISTS ( 17 SELECT JobHisto.JobId 18 FROM JobHisto 19 WHERE JobHisto.Jobid = Job.JobId 20 ) 21 AND JobTDate < %s 22