From 3318fdece6f7b7fda26621c0597ac6bbfb48fb1a Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 25 Feb 2007 16:40:01 +0000 Subject: [PATCH] ebl init git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@4252 91ce42f0-d328-0410-95d8-f526ca767f89 --- gui/bweb/script/update_job_old.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 gui/bweb/script/update_job_old.sql diff --git a/gui/bweb/script/update_job_old.sql b/gui/bweb/script/update_job_old.sql new file mode 100644 index 0000000000..abd9962665 --- /dev/null +++ b/gui/bweb/script/update_job_old.sql @@ -0,0 +1,8 @@ +-- First, create job_old table +-- CREATE TABLE job_old (LIKE Job); +-- +-- 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) ); + -- 2.39.5