hi, 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.
sql query: UPDATE Media SET VolStatus = 'Full' WHERE (VolStatus = 'Append' or VolStatus = 'Used') AND LastWritten < NOW() - interval 7 DAY thanks for idees. greetings manuel staechele -- 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] ------------------------------------------------------------------------- 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