From fa646f5bfd99babf197228f95a3250b2806d1e13 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 5 Mar 2007 09:19:40 +0000 Subject: [PATCH] ebl add only ended backup git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/branches/Branch-2.0@4309 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