DECLARE
   -- V_CNT   NUMBER := 0;
   V_STATUS   user_scheduler_job_run_details.STATUS%TYPE;
BEGIN
   FOR I IN (SELECT ENABLED_FLAG
               FROM JOB_STATUS
              WHERE job_name = 'JOB_NAME')
   LOOP
      IF I.ENABLED_FLAG = 'E'     --Not allowed to check in Maintenance window
      THEN
         BEGIN
            SELECT ASJRD.STATUS
              INTO V_STATUS
              from user_scheduler_job_run_details asjrd
             WHERE asjrd.job_name = 'JOB_NAME'
                   AND (   SYSDATE - (1 / (24 * 60) * 10) <= ASJRD.log_date
                        OR (    SYSDATE - (1 / (24 * 60) * 10) <=
                                   ASJRD.log_date
                            AND ASJRD.STATUS <> 'FAILED'))
                   AND ROWNUM = 1;
         EXCEPTION
            WHEN NO_DATA_FOUND                    --No rows in last 10 minutes
            THEN
               raise_application_error (
                  -20101,
                  'No rows found for the last 10 minutes');
         END;
 
 
         IF (V_STATUS = 'FAILED')                   --Error in last 10 minutes
         THEN
            raise_application_error (-20101,
                                     'Error found for the last 10 minutes');
         END IF;
      END IF;
   END LOOP;
END;