Hi list, It's late and I'm in a little bit of a pickle . The problem is synchronizing a text index using a job. I create the job fine, but I query user_jobs, and I keep on getting failures . I create the job (with suitable account privs) with the following. DECLARE v_jobno number; BEGIN dbms_job.submit(job=>v_jobno, what=>'ctx_ddl.sync_index(''"FOOBAR"."SEARCH_IDX"'' );', next_date=>sysdate+1/24, interval=>'sysdate+1/24'); END; The job is created fine. I run exec ctx_ddl.sync_index('"FOOBAR"."SEARCH_IDX"'); and it works fine and dandy, but every time the job is invoked it returns an error. Anyone have any ideas ? Is there a better way to do this???? (I hate having to depend on a job for this) BTW I'm doing this on my laptop which is 9.2.0.1.0 on Win XP.. Thanks in advance Nelson