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

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users