Hello Steven,
You might take a looks that the patch that Ulrich Leodolter
sent to the bacula-devel list on 1/7/2014 at 2:14pm. It may
or may not do what you want. I am currently looking at that
patch with an eye to integrate it into Bacula, but I don't fully
understand it yet so I am not sure it will satisfy your needs.
Just so it is clear, his patch as such probably does not do what
you want, but he has an example above the actual patch that
is interesting.
Best regards,
Kern
On 01/14/2014 03:43 PM, 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
> to suggestions. Here is the current configuration for the disk to tape copy:
>
> JobDefs {
> Name = Default-Disk-to-Tape-Job
> Type = Copy
> Schedule = Disk-to-Tape-Schedule
> Client = None
> Fileset = None
> Pool = Daily-Incr
> Storage = File
> Messages = Standard
>
> Priority = 90
>
> Spool Data = no
> Spool Attributes = yes
>
> }
>
> job {
> Name = Disk-to-Tape
> JobDefs = Default-Disk-to-Tape-Job
> Selection Type = SQLQuery
> Selection Pattern = "
> SELECT J.JobId
> FROM Job J, Pool P
> WHERE P.Name = 'Daily-Incr' <== Hardcoded for now just
> to get it to work
> AND P.PoolId = J.PoolId
> AND J.Type = 'B'
> AND J.JobStatus IN ('T','W')
> AND J.JobBytes > 0
> AND J.StartTime >= NOW() - INTERVAL '24 hours'
> AND J.JobId NOT IN (SELECT PriorJobId FROM Job
> WHERE Type IN ('B','C')
> AND Job.JobStatus IN ('T','W')
> AND PriorJobId != 0)
> ORDER BY J.JobId;"
> }
>
> Schedule {
> Name = Disk-to-Tape-Schedule
> Run = Level=Full Pool=Monthly-Full FullPool=Monthly-Full 1st fri at 22:00
> Run = Level=Differential Pool=Weekly-Diff DifferentialPool=Weekly-Diff
> 2nd-5th fri at 22:00
> Run = Level=Incremental Pool=Daily-Incr IncrementalPool=Daily-Incr mon-thu
> at 22:00
> }
>
> Thanks for any 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: 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 +0000, 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
>> copy but us a SQL QUERY instead of the PoolUncopiedJobs. But I need to use
>> the POOL name that is supplied in our SCHEDULE setup (incremental,
>> differential, full). Here is the query, but of course it doesn't work and I
>> was hoping someone could enlighten me on how to accomplish it. Thanks.
>>
>
> Dumb question: Why don't you select by JobLevel? Are you copying to
> separate pools?
>
> All the best, Uwe
>
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
