Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql,v diff -u -r1.8 -r1.8.8.1 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql 17 May 2003 09:43:09 -0000 1.8 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql 7 Apr 2006 00:48:49 -0000 1.8.8.1 @@ -103,62 +103,3 @@ return 0; end;' language 'plpgsql'; - - - --- show errors - --- initialize the scheduled publication job - --- Job scheduling has been moved to aolserver for both the oracle and --- postgresql versions. DanW - -create function inline_1 () -returns integer as ' -declare - v_job_id integer; - interval integer default 15; -begin - - select job into v_job_id from user_jobs - where what = ''cr_scheduled_release_exec;''; - - if NOT FOUND then - raise NOTICE '' - Submitting job to process scheduled updates to live content...''; - - dbms_job__submit( - job => v_job_id, - what => ''cr_scheduled_release_exec;'', - next_date => now(), - interval => ''now() + '' || (interval/24/60) - ); - - update cr_scheduled_release_job set job_id = v_job_id; - else - - dbms_job__change( - job => v_job_id, - what => ''cr_scheduled_release_exec;'', - next_date => now(), - interval => ''now() + '' || (interval/24/60) - ); - - end if; - - return 0; -end;' language 'plpgsql'; - --- select inline_1 (); - -drop function inline_1 (); - - --- show errors - - - - - - -