OraFAQ Forum: Enterprise Manager » Error while creating a job from Oracle 9i EM

Home » RDBMS Server » Enterprise Manager » Error while creating a job from Oracle 9i EM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while creating a job from Oracle 9i EM [message #194146]

Thu, 21 September 2006 00:06

srikanth_anumalasetty
Messages: 1
Registered: September 2006
Location: Bangalore

Junior Member

Hi All,

I am using oracle 9i, i am facing problem while scheduling a job through Enterprise Manager. My requirement is, i am having an index which i want to reindex for every 30 min.

The code that i placed inside the new job is "ctx_ddl.sync_index('PAGECONTENTS_INDEX');" but it is giving an error message of

ORA-23421: job number 2 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 526
ORA-06512: at "SYS.DBMS_JOB", line 169
ORA-06512: at line 1

Can any one please help me out.

Thanks in advance

Sri

Report message to a moderator

Previous Topic:	Not able to list in host after reinstalling Oracle10g grid
Next Topic:	10g Windows Grid Control change sysman pwd

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:06:39 CST 2024