title: Run oracle query (SQL) every 30 seconds and once count equals 8 it should proceed further and finish the job
body: <p>I was looking for a solution to my problem on the internet, however I could not find fit for purpose solution. Can some please help and guide me with some examples.</p>
  
  <p>In Oracle em console I have a job that runs for at least for 1 hour and during the job running process it will update few tables in Oracle.</p>
  
  <p>Basically I want SQL query to run every 1 minute and once count equals 8 it should stop and move ahead....</p>
  
  <p>TABLE_NAME: TASK - This table will get updated during 1 hour processing</p>
  
  <pre><code>ID TYPE_ID VALUE
  1  12      TEST1
  2  13      TEST2
  3  14      TEST3
  4  15      TEST4
  5  16      TEST5
  </code></pre>
  
  <p>Appreciate your help.</p>