DML job queue problem
From: Craig Taylor <craigtaylor2_at_home.com>
Date: Thu, 12 Apr 2001 18:22:13 GMT
Message-ID: <3AD5F115.4270D6D8_at_home.com>
BEGIN
EXECUTE IMMEDIATE
/
END;
/
Date: Thu, 12 Apr 2001 18:22:13 GMT
Message-ID: <3AD5F115.4270D6D8_at_home.com>
Hi,
I have created a .sql file which creates a strored procedure to sync my intermedia index on a job queue. The problem I am having is that my jobs seem to just stop, and disappear after a couple of days. Here is what I do to set up my job queues:
- start my ctx server unix command line prompt:
>ctxsrv -user ctxsys/ctxsys -personality M -log ctx.log &
- load my .sql file: ////////////STORED PROCEDURE
BEGIN
EXECUTE IMMEDIATE
'ALTER INDEX PROD_INDEX' || ' REBUILD' || 'PARAMETERS ( ''SYNC'')' ;END PROD_INDEX_SYNC;
/
///////////CREATE JOB QUEUE
VARIABLE JOB1 NUMBER;
BEGIN
DBMS_JOB.SUBMIT (:JOB1, 'PROD_INDEX_SYNC;'. ((SYSDATE +1) + 710/1440)); COMMIT;
END;
/
Everything loads up fine, and the jobs show up when I select job from user_jobs, but if I manually run it using DBMS_JOB.RUN(12); the job disappears (when I select job from user_jobs). It also will just disappear after a few days. I'm not really sure what is happening.
I appreciate the help,
Thanks,
Craig
-- "We dance around in a ring and suppose, But the Secret sits in the middle and knows." Robert FrostReceived on Thu Apr 12 2001 - 20:22:13 CEST