> I would not recommend doing this, and instead limiting media use by > VolumeUseDuration or MaximumVolumeJobs. Homegrown queries are probably > not the easiest things to follow in the future, and there is really no > need for them, I wouldn't think.
we tried VolumeUseDuration but the result was that the status of media switch to used but will not re used, so did not purge or prune the volume that we can a next job can use the volume again. so my question did you sucessfull test the VolumeUseDuration your self or only in theory? we tried this a few month ago so it can be that it work in newer bacula versions? > Manuel Staechele wrote: >>>> i want every media LastWritten 7 days ago to go in full status. >>>> because if the media is append, it will not automatic pruned >>>> i have wrote a little sql query to do the job, but want ask if there is >>>> a better, than execute the sql query every day. >>> I'll let others on this list answer your question, but in your SQL below, I >>> see no reason to change a Used status to Full. >>> >>>> sql query: >>>> >>>> UPDATE Media SET >>>> VolStatus = 'Full' >>>> WHERE (VolStatus = 'Append' or VolStatus = 'Used') >>>> AND LastWritten < NOW() - interval 7 DAY >> >> yes ok, my failure i was not sure about status Used. >> >> so i want to update Media Table after Job BackupCatalog. Is there any >> other solution for what i want? >> >> thanks in advance >> >> manuel >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share your >> opinions on IT & business topics through brief surveys - and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users > > - -- > ---- _ _ _ _ ___ _ _ _ > |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III > |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) > \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.5 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFFwL0xmb+gadEcsb4RAu3fAJwNTMQck3t1OTpfB9eY+5ymZz//OwCeKGXX > XNJqvllSoOmdgZ166IMtLas= > =dtRf > -----END PGP SIGNATURE----- > -- Mit freundlichen Grüssen Manuel Stächele **************************************** Dr. Levante GmbH & Co.KG, Netzwerkbetreuung und Software-Entwicklung Hauptstrasse 46, 79639 Grenzach - Wyhlen, Deutschland Tel: +49 7624 9167-10 Fax: +49 7624 80562 Email: [EMAIL PROTECTED] oder [EMAIL PROTECTED] ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
