On Mon, Aug 2, 2010 at 5:00 PM, Jeremiah D. Jester <jj...@u.washington.edu> wrote: > I have quite a few jobs that have failed for various reasons. Since these are > incomplete jobs, I would like to take the media and recycle them back into > the pool as we are running low on tapes. > > I am able to identify the volumes related to the specific failed job. > However, I do want to check to see if these volumes are associated with any > other jobs so I don't accidently wipe out other jobs. > > Does anyone know how I might identify all jobs on a specific volume? >
query 14 *query Available queries: 1: List up to 20 places where a File is saved regardless of the directory 2: List where the most recent copies of a file are saved 3: List last 20 Full Backups for a Client 4: List all backups for a Client after a specified time 5: List all backups for a Client 6: List Volume Attributes for a selected Volume 7: List Volumes used by selected JobId 8: List Volumes to Restore All Files 9: List Pool Attributes for a selected Pool 10: List total files/bytes by Job 11: List total files/bytes by Volume 12: List Files for a selected JobId 13: List Jobs stored on a selected MediaId 14: List Jobs stored for a given Volume name 15: List Volumes Bacula thinks are in changer 16: List Volumes likely to need replacement from age or errors 17: List Volumes Bacula thinks are full and in changer 18: Get all the Jobids for a job 19: List Volumes by status 20: List where the most recent copies of folder Choose a query (1-20): 14 Enter Volume name: A00052 +--------+-----------------------------+---------------------+------+-------+---------+-----------------+--------+ | jobid | name | starttime | type | level | files | bytes | status | +--------+-----------------------------+---------------------+------+-------+---------+-----------------+--------+ | 21,780 | BreastConeBeamCTArchive-Job | 2010-07-06 15:20:36 | B | I | 359,799 | 382,912,010,067 | T | | 21,797 | SCCORArchive-Job | 2010-07-08 09:03:37 | B | I | 21,011 | 11,035,952,565 | T | | 21,898 | PLuSSArchive-Job | 2010-07-19 05:46:27 | B | I | 5,729 | 2,999,968,152 | T | | 21,899 | PRO09070131-Archive-Job | 2010-07-19 13:30:45 | B | F | 375 | 6,728,175,230 | T | | 21,900 | IRB0601002-Archive-Job | 2010-07-19 13:41:45 | B | F | 200 | 98,143,038 | T | | 21,901 | PRO09070131-Archive-Job | 2010-07-19 13:46:30 | B | I | 29 | 0 | T | | 21,922 | IRB0601002-Archive-Job | 2010-07-21 08:39:24 | B | I | 1 | 0 | T | | 21,923 | IRB0601002-Archive-Job | 2010-07-21 11:40:20 | B | F | 2,199 | 28,709,501,042 | T | | 21,944 | SARP-Archive-Job | 2010-07-23 08:11:24 | B | I | 8,287 | 4,360,314,222 | T | | 21,975 | SARP-Archive-Job | 2010-07-26 08:11:36 | B | I | 1,884 | 991,829,792 | T | | 21,986 | SARP-Archive-Job | 2010-07-27 13:25:21 | B | I | 1,610 | 846,989,718 | T | | 21,998 | BreastConeBeamCTArchive-Job | 2010-07-28 14:58:54 | B | I | 56,296 | 57,601,152,105 | T | | 22,029 | PLuSSArchive-Job | 2010-07-30 13:06:30 | B | I | 0 | 0 | T | +--------+-----------------------------+---------------------+------+-------+---------+-----------------+--------+ * ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users