Index: openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	1 Jul 2002 19:35:30 -0000	1.8
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	20 Sep 2002 21:19:00 -0000	1.9
@@ -7,7 +7,8 @@
         <querytext>
             select notification_id
             from notifications
-            where not exists (select notifications.notification_id
+            where sysdate - notif_date > 2
+              and not exists (select notifications.notification_id
                               from notifications,
                                    notification_requests,
                                    notification_user_map
@@ -27,8 +28,7 @@
                    notification_requests.user_id,
                    notification_requests.type_id,
                    notification_requests.delivery_method_id,
-                   notifications.response_id,
-                   acs_object.name(notifications.object_id) as object_name
+                   notifications.response_id
             from notifications,
                  notification_requests,
                  notification_user_map