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>


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:

  1. start my ctx server unix command line prompt:
    >ctxsrv -user ctxsys/ctxsys -personality M -log ctx.log &
  2. load my .sql file: ////////////STORED PROCEDURE
CREATE OR REPLACE PROCEDURE PROD_INDEX_SYNC  IS
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 Frost
Received on Thu Apr 12 2001 - 20:22:13 CEST

Original text of this message