Re: [Bacula-users] Verify and admin job retention

[Jeremy M. <jm...@sc...>]

Op 29/12/2010 21:00, Martin Simmons schreef:
>>>>>> On Wed, 29 Dec 2010 13:32:28 +0100, Jeremy Maes said:
>> When checking some things at our clients' sites where we are testing
>> bacula I found out that
>> our retention periods (and auto-pruning) don't seem to work for verify
>> jobs and admin jobs.
>>
>> We are using general 30d File and Job retention periods everywhere, and
>> 6d, 20d or 81d volume retention periods for our volumes in the pool
>> configs, depending on the type (daily, weekly, monthly)
> Yes, I had problems with that too so I run the sql command
>
> delete from job
>         where type in ('V', 'D')
>               and starttime<  now()-interval '2 months'
>
> every week to remove them.
>
> I think one problem is that Volume Retention doesn't remove them because they
> are not associated with any particular volumes, so they hang around for much
> longer than expected.
>
> __Martin

Ah, shows me again that I should start thinking more in terms of SQL 
statements when it comes to that kind of thing.

Thanks for the code, will definitely try it out and implement it as a 
weekly job.
Will also look into the existing bugs and report it if necessary as I 
don't think this is desireable behaviour.

Kind regards,
Jeremy

 **** DISCLAIMER ****
http://www.schaubroeck.be/maildisclaimer.htm