>> 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
