title: How to create a trigger on user_scheduler_jobs in oracle?
body: <p>I am new to oracle. In our application, we need to execute a procedure when the run duration of a scheduled job exceeds 10 minutes. We are checking in <code>user_scheduler_jobs</code> table and have to fire a procedure when the <code>last_run_duration</code> column exceeds 10 minutes. We tried to create a trigger for this purpose as shown below : </p>
  
  <pre><code>CREATE TRIGGER TRG1
    AFTER UPDATE ON ALL_SCHEDULER_JOBS
    BEGIN
    MONITOR_JOB_DURATION();
    END TRG1;
  </code></pre>
  
  <p>But when I try to compile the trigger it is showing an error as </p>
  
  <pre><code>Error report:
  ORA-25001: cannot create this trigger type on views
  25001. 00000 -  "cannot create this trigger type on views"
  *Cause:    Only INSTEAD OF triggers can be created on a view.
  *Action:   Change the trigger type to INSTEAD OF.
  </code></pre>
  
  <p>Is <code>user_scheduler_jobs</code> a view? 
  If I proceed with <code>INSTEAD OF</code> trigger, will it effect the updation which is automatically happening after job execution?</p>