From 5bc6ecce79e0be30df6a2faaf14a39d7fe19d922 Mon Sep 17 00:00:00 2001 From: Marcin Haba Date: Tue, 12 Apr 2022 12:52:23 +0200 Subject: [PATCH] Fix #9035 update job statistics --- bacula/src/cats/sql_cmds.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index db8734afa..756dc6a2c 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -54,12 +54,12 @@ const char *fill_jobhisto = "SchedTime, StartTime, EndTime, RealEndTime, JobTDate," "VolSessionId, VolSessionTime, JobFiles, JobBytes, ReadBytes," "JobErrors, JobMissingFiles, PoolId, FileSetId, PriorJobId, PriorJob, " - "PurgedFiles, HasBase, Reviewed, Comment)" + "PurgedFiles, HasBase, HasCache, Reviewed, Comment, FileTable)" "SELECT JobId, Job, Name, Type, Level, ClientId, JobStatus," "SchedTime, StartTime, EndTime, RealEndTime, JobTDate," "VolSessionId, VolSessionTime, JobFiles, JobBytes, ReadBytes," "JobErrors, JobMissingFiles, PoolId, FileSetId, PriorJobId, PriorJob, " - "PurgedFiles, HasBase, Reviewed, Comment " + "PurgedFiles, HasBase, HasCache, Reviewed, Comment, FileTable " "FROM Job " "WHERE JobStatus IN ('T','W','f','A','E')" "AND NOT EXISTS " -- 2.47.3