DBMS_JOB.SUBMIT : DBMS_JOB « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_JOB
SQL>
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>








31.11.DBMS_JOB
31.11.1.DBMS_JOB demonstration
31.11.2.DBMS_JOB.SUBMIT
31.11.3.Submit a job and run
31.11.4.Submit a job and query the user_jobs
31.11.5.Job number
31.11.6.Use dbms_job.submit to call 'execute immediate'
31.11.7.Submit job to change password
31.11.8.Schedule the procedure to run now and every night at 3 AM: