From ec4aeb9fbe2120db337e830a2201e9d6730efe89 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 5 Mar 2007 09:19:06 +0000 Subject: [PATCH] ebl add only ended backup git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@4308 91ce42f0-d328-0410-95d8-f526ca767f89 --- gui/bweb/script/update_job_old.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gui/bweb/script/update_job_old.sql b/gui/bweb/script/update_job_old.sql index abd9962665..a922246a4b 100644 --- a/gui/bweb/script/update_job_old.sql +++ b/gui/bweb/script/update_job_old.sql @@ -4,5 +4,5 @@ -- then put this on your crontab -- */20 * * * * psql -f /opt/bacula/etc/update_job_old.sql > /home/bacula/update_job_old.log INSERT INTO job_old - (SELECT * FROM Job WHERE JobId NOT IN (SELECT JobId FROM job_old) ); + (SELECT * FROM Job WHERE JobStatus in ('T', 'f', 'A') AND JobId NOT IN (SELECT JobId FROM job_old) ); -- 2.39.5