On Mon, Dec 24, 2012 at 05:48:35PM -0500, K. M. Peterson wrote: > Hi Mark, > > I have two jobs that I run periodically. > > query_errvols.sql generates a list of volumes that were written by failed > jobs. If a job failed, or was cancelled, it gets returned by this program. > query_orphan_volumes.sql does the same for volumes that are in the Media > table with no corresponding JobMedia entry. (For our operations, we're > also only interested in volumes in Pools with a PoolId between 2 and 5 > inclusive. >
Thanks for sharing! All the best, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
