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) + + +