This discussion is archived
0 Replies Latest reply: Aug 25, 2012 1:56 AM by malik_Rahul RSS

Error in creating event based  jobs.

malik_Rahul Newbie
Currently Being Moderated
while trying to creating event based jobs. I am getting below error

ORA-00904: "SYS"."SCHEDULER$_QP_5187"."F3": invalid identifier
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 295
ORA-06512: at line 2


I am using 10g database.

Even below small procedure is not working.
begin 
DBMS_SCHEDULER.create_job 
                     ('test1F' , 
                      job_type             => 'plsql_block', 
                      job_action           =>    'begin  test_proc end;', 
                      event_condition      =>    'tab.user_data.object_name ='' test''  and  tab.user_data.event_type = ''JOB_FAILED''', 
                      queue_spec           => 'sys.scheduler$_event_queue,myagent', 
                      enabled              => TRUE 
                     ); 
end; 
and

Myagent is subscribe to
SELECT consumer_name
  FROM dba_queue_subscribers
 WHERE queue_name = 'SCHEDULER$_EVENT_QUEUE';


MYAGENT
SCHEDULER$_EVENT_AGENT
Edited by: ma**** on 25-Aug-2012 01:55

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points