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