Index: openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql 20 Oct 2003 15:14:20 -0000 1.11
+++ openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql 15 Nov 2017 15:56:49 -0000 1.12
@@ -31,14 +31,6 @@
-
-
- update auth_batch_jobs
- set doc_start_time = sysdate
- where job_id = :job_id
-
-
-
update auth_batch_jobs
@@ -52,17 +44,6 @@
-
-
-
- update auth_batch_jobs
- set job_end_time = sysdate,
- message = :message
- where job_id = :job_id
-
-
-
-
@@ -75,15 +56,6 @@
-
-
-
- delete from auth_batch_jobs
- where job_end_time < sysdate - :num_days
-
-
-
-
Index: openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql 17 Oct 2003 11:09:58 -0000 1.8
+++ openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql 15 Nov 2017 15:56:49 -0000 1.9
@@ -31,14 +31,6 @@
-
-
- update auth_batch_jobs
- set doc_start_time = current_timestamp
- where job_id = :job_id
-
-
-
update auth_batch_jobs
@@ -51,17 +43,6 @@
-
-
-
- update auth_batch_jobs
- set job_end_time = current_timestamp,
- message = :message
- where job_id = :job_id
-
-
-
-
@@ -73,13 +54,4 @@
-
-
-
- delete from auth_batch_jobs
- where job_end_time < current_timestamp - interval '$num_days days'
-
-
-
-
Index: openacs-4/packages/acs-authentication/tcl/sync-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-authentication/tcl/sync-procs.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-authentication/tcl/sync-procs.xql 11 Sep 2003 16:11:11 -0000 1.2
+++ openacs-4/packages/acs-authentication/tcl/sync-procs.xql 15 Nov 2017 15:56:49 -0000 1.3
@@ -2,6 +2,25 @@
+
+
+ update auth_batch_jobs
+ set doc_start_time = current_timestamp
+ where job_id = :job_id
+
+
+
+
+
+
+ update auth_batch_jobs
+ set job_end_time = current_timestamp,
+ message = :message
+ where job_id = :job_id
+
+
+
+
select e.entry_id,
@@ -24,4 +43,11 @@
+
+
+ delete from auth_batch_jobs
+ where job_end_time < current_date - cast(:num_days as integer)
+
+
+