-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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.
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----- ------------------------------------------------------------------------- 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
