Re: [Bacula-users] Variable Expansion in SQL QUERY

2014-01-17 Thread Kern Sibbald
assistance. I'm still relatively new to Bacula but have > enjoyed the learning experience. > > Steven Hammond > I.T. Manager > Technical Chemical Company > > For support, please email us at supp...@technicalchemical.com. > > > -Original Message- > From: Uw

Re: [Bacula-users] Variable Expansion in SQL QUERY

2014-01-14 Thread Steven Hammond
No. They are like this: Pool: Daily-Incr, Next Pool: Daily-Tape Pool: Weekly-Diff, Next Pool: Weekly-Tape Pool: Monthly-Full, Next Pool: Monthly-Tape On 1/14/14 8:53 AM, "Uwe Schuerkamp" wrote: >On Tue, Jan 14, 2014 at 02:43:47PM +, Steven Hammond wrote: >> We have separate pools for eac

Re: [Bacula-users] Variable Expansion in SQL QUERY

2014-01-14 Thread Uwe Schuerkamp
On Tue, Jan 14, 2014 at 02:43:47PM +, Steven Hammond wrote: > We have separate pools for each level (incremental, differential, full). I > have 1 schedule and 1 job for the disk to tape copy and was just trying to > keep it that way. I know I could create separate jobs/schedules. I'm open

Re: [Bacula-users] Variable Expansion in SQL QUERY

2014-01-14 Thread Steven Hammond
hnicalchemical.com. -Original Message- From: Uwe Schuerkamp [mailto:uwe.schuerk...@nionex.net] Sent: Tuesday, January 14, 2014 8:30 AM To: Bacula Users Mailing List Subject: Re: [Bacula-users] Variable Expansion in SQL QUERY On Tue, Jan 14, 2014 at 02:17:12PM +, Steven Hammond wrote: &

Re: [Bacula-users] Variable Expansion in SQL QUERY

2014-01-14 Thread Uwe Schuerkamp
On Tue, Jan 14, 2014 at 02:17:12PM +, Steven Hammond wrote: > I've decided to write my on SQL QUERY to just copy jobs that haven't been > copied in the last 24 hours (disk to tape backup follows on the heels on the > disk to disk backup). I wanted to just keep the same JOB for disk to tape

[Bacula-users] Variable Expansion in SQL QUERY

2014-01-14 Thread Steven Hammond
I've decided to write my on SQL QUERY to just copy jobs that haven't been copied in the last 24 hours (disk to tape backup follows on the heels on the disk to disk backup). I wanted to just keep the same JOB for disk to tape copy but us a SQL QUERY instead of the PoolUncopiedJobs. But I need t