CREATE OR REPLACE
PROCEDURE process_commission
IS
  l_salsum NUMBER;
BEGIN
  SELECT SUM(sal)
  INTO l_salsum
  FROM emp
  WHERE hiredate>=TRUNC(SYSDATE)
  AND hiredate   <TRUNC(SYSDATE-7);
  IF l_salsum    >10000 THEN
    UPDATE emp SET sal=sal+sal*0.02;
  END IF;
END;

BEGIN
  DBMS_SCHEDULER.create_job (
    job_name        => 'process_commission_job',
    JOB_TYPE        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN process_commission; END;',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'freq=daily; byhour=5; byminute=00; bysecond=0;',
    end_date        => NULL,
    enabled         => TRUE,
    comments        => 'Job defined to update the commission.');
END;
/

declare
l_salsum NUMBER;
BEGIN
  SELECT SUM(sal)
  INTO l_salsum
  FROM emp
  WHERE hiredate>=TRUNC(SYSDATE)
  AND hiredate   <TRUNC(SYSDATE-7);
  IF l_salsum    >10000 THEN
    UPDATE emp SET sal=sal+sal*0.02;
  END IF;
END;