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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|