3 Replies Latest reply: Aug 24, 2012 4:41 PM by 126955 RSS

    Error While creating Event based jobs

    malik_Rahul
      while creating even 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
      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

      myagenit is subscribe to sys.scheduler$_event_queue
      SELECT consumer_name
        FROM dba_queue_subscribers
       WHERE queue_name = 'SCHEDULER$_EVENT_QUEUE';
       
       
      MYAGENT
      SCHEDULER$_EVENT_AGENT