Hi,
Thanks for your pointer Phil - it seems to be valid now.
However, I am still unable to see what this query is doing :-(. If I run it against my catalogue DB, I just get a long list of JobIDs, which don't look right for my SVN_Full pool. I have a feeling I may be over complicating thigs using a SQL query?
Re-reading the documentation on Copy and Migration, there's a job option, which I had missed last time I read the page:
Thanks for your pointer Phil - it seems to be valid now.
However, I am still unable to see what this query is doing :-(. If I run it against my catalogue DB, I just get a long list of JobIDs, which don't look right for my SVN_Full pool. I have a feeling I may be over complicating thigs using a SQL query?
Re-reading the documentation on Copy and Migration, there's a job option, which I had missed last time I read the page:
- PoolUncopiedJobs
- This selection which copies all jobs from a pool to an other pool which were not copied before is available only for copy Jobs.
What are the pro's/con's with this option, over a SQL query, such as the one kindly suggested by Adrian Reyer a few days ago?
Thanks,
Joe
On 15 Jan, 2012,at 10:47 PM, Phil Stracchino <ala...@metrocast.net> wrote:
On 01/15/2012 04:17 PM, Joe Nyland wrote:
> select a.JobId from Job AS a JOIN Pool AS b
> ON a.PoolId=b.PoolId AND b.Name!='ARCH'
> AND b.Name!='TAPE'
> WHERE a.Type='B' AND a.JobID NOT IN
> (SELECT PriorJobId FROM Job AS c JOIN Pool AS d
> ON c.PoolId=d.PoolId AND d.Name='ARCH')
> AND a.EndTime>(now()-INTERVAL '10 DAY') ORDER BY a.StartTime ASC;
Drop the quotes around 10 DAY.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------ RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
