title: What will be the procedure to run a job scheduler to send mails on apex oracle?
body: <p>I have an apex application where i need to send a notification mail to all the employees on the 5th of every month. So just for the sake of testing i am trying to send a mail in every 30 seconds. I created a job scheduler on a procedure to do the same. Here is the PLSQL code for it.</p>
  
  <pre><code>create or replace procedure send_notification_employee as
  cursor c_employee is select * from EMPLOYEE;
  r_employee c_employee%ROWTYPE;
  begin
      open c_employee;
      loop
          fetch c_employee into r_employee;
          exit when c_employee%NOTFOUND;
          APEX_MAIL.SEND(
          p_to        =&gt; r_employee.EMPLOYEE_EMAIL,
          p_from      =&gt; 'abc@gmail.com',
          p_subj      =&gt; 'Reminder : Meeting',
          p_body      =&gt; '&lt;Some random message&gt;');
      end loop;
      close c_employee;
  end;
  /
  
  begin    
  DBMS_SCHEDULER.CREATE_JOB(
      job_name =&gt; 'send_notification',
      job_type =&gt; 'stored_procedure',
      job_action =&gt; 'send_notification_employee',
      start_date =&gt; NULL,
      repeat_interval =&gt; 'FREQ=SECONDLY;INTERVAL=30',
      end_date =&gt; NULL);
  end;
  /
  
  begin
  DBMS_SCHEDULER.enable(
      name =&gt; 'send_notification');
  end;
  /
  </code></pre>
  
  <p>I guess the code is correct. The only thing i am not sure of is to how to run this scheduler on the apex oracle application. Should i just execute these statements on the SQL Commands or is there any other way to do it?</p>
  
  <p>Also i tried to execute the same statements in the SQL Commands tab but i don't receive any mails as such. Is there any issue with my code? Thanks in advance.</p>