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