Using the SUBMIT Procedure : dbms_job « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_job

Using the SUBMIT Procedure

   
SQL>
SQL> DECLARE
  2   v_job NUMBER;
  3   v_what VARCHAR2(1000) := 'insert into test_table values (9999);';
  4   BEGIN
  5   dbms_job.submit(job => v_job,
  6                   what => v_what,
  7                   next_date => sysdate,
  8                   interval => 'sysdate + 1/24');
  9    COMMIT;
 10    END;
 11   /


SQL>








Related examples in the same category

1.Simple Procedure with SUBMIT
2.Using DBMS_OUTPUT to See the Assigned Job Number
3.DBMS_JOB package.
4.Use dbms_job.submit to call 'execute immediate'
5.Remove a procedure from the queue after 5 executions.
6.how to submit TempInsert as a job.
7.Submit job to change password