title: Stop Scheduler Job - Exit Point in PL/SQL Block
body: <pre><code>DBMS_SCHEDULER.CREATE_JOB (
      job_name =&gt; 'MYJOB', 
      job_type =&gt; 'PLSQL_BLOCK',
      job_action =&gt; &lt;see below&gt;
  );
  
  DBMS_SCHEDULER.ENABLE (
      name =&gt; 'MYJOB'
  );
  
  -- pl/SQL block for the job:
  
  BEGIN
      -- 1
      UPDATE ...
      COMMIT;
  
      FOR x IN (SELECT ...
      LOOP
          -- 2
          UPDATE ...
          COMMIT;
      END LOOP;
  
      -- 3
      UPDATE ...
      COMMIT;
  END
  </code></pre>
  
  <p>When I execute</p>
  
  <pre><code>DBMS_SCHEDULER.STOP_JOB (
      job_name =&gt; 'MYJOB', 
      force =&gt; FALSE
  );
  </code></pre>
  
  <p>is there a special rule in the scheduler for terminating PL/SQL blocks at a special point within the PL/SQL block? In the example above, is it possible that the DML at Point "3" is not executed?</p>