1 -- First, create JobHistory table
2 -- CREATE TABLE JobHistory (LIKE Job);
4 -- then put this on your crontab
5 -- */20 * * * * psql -f /opt/bacula/etc/update_job_old.sql > /home/bacula/update_job_old.log
7 (SELECT * FROM Job WHERE JobStatus in ('T', 'f', 'A') AND JobId NOT IN (SELECT JobId FROM JobHistory) );