0 Replies Latest reply: Aug 25, 2012 3:56 AM by malik_Rahul RSS

    Error in creating event based  jobs.

    malik_Rahul
      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