Re: [Bacula-users] Need some help with copy jobs
2012-01-15 17:49:40
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
alaric AT caerllewys DOT net alaric AT metrocast DOT net phil AT
co.ordinate DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|