Confusing CTXSYS issue

From: macdba321 <>
Date: Wed, 16 Sep 2009 08:51:49 -0700 (PDT)
Message-ID: <>

Platform: Win2003 SP2 64-bit

  I created a context index. It has a sync every 24 hours on it, but it does not seem to be automatically syncing now. (If I "call ctx_dll.sync_index" on it, it works great.)

How can I verify that it is registered to continue to re-sync? A "select * from dba_jobs" returns 0 results.

Thank you.

FYI: This is the create index syntax:

create index idx_ry_resource_meta on ry_resource (m_extensions)   indextype is ctxsys.context parameters   ('FILTER CTXSYS.NULL_FILTER SECTION
   SYNC (EVERY "TRUNC(SYSDATE)+1")'); Received on Wed Sep 16 2009 - 10:51:49 CDT

Original text of this message