add per-customer "Invoice reports" link, RT#13802

[freeside.git] / FS / bin / freeside-cdrd

diff --git a/FS/bin/freeside-cdrd b/FS/bin/freeside-cdrd
index 1346531..2cf75f3 100644 (file)
--- a/FS/bin/freeside-cdrd
+++ b/FS/bin/freeside-cdrd
@@ -55,8 +55,8 @@ my $extra_sql =
     )
     AND 0 = (
       SELECT COUNT(*) FROM queue
-        WHERE job = 'FS::cust_main::queued_bill'
-          AND job.custnum = cust_pkg.custnum
+        WHERE queue.job = 'FS::cust_main::queued_bill'
+          AND queue.custnum = cust_pkg.custnum
     )
     
   ";
@@ -108,7 +108,7 @@ while (1) {
   }
 
   myexit() if sigterm() || sigint();
-  sleep 5; # unless $found;
+  sleep 1 unless $found;
 
 }