Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

DBMS_JOB SUBMIT

SQL> SQL> DECLARE   2     lv_job_num NUMBER;   3  BEGIN   4     DBMS_JOB.SUBMIT(lv_job_num, 'LOG_SOURCE;', SYSDATE, 'SYSDATE + 1/24', NULL);   5     DBMS_OUTPUT.PUT_LINE('Assigned Job #: ' || lv_job_num);   6  END;   7  / PL/SQL procedure successfully completed. SQL>