Using DBMS_OUTPUT to See the Assigned Job Number : dbms_job « System Packages « Oracle PL / SQL






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

Using DBMS_OUTPUT to See the Assigned Job Number

   
SQL> --
SQL> DECLARE
  2       v_jobnum BINARY_INTEGER;
  3  BEGIN
  4       DBMS_JOB.SUBMIT(v_jobnum,'HELLO;',SYSDATE,
  5            'SYSDATE + (1/(24*60*60))');
  6       DBMS_OUTPUT.ENABLE;
  7       DBMS_OUTPUT.PUT_LINE('Your Job Number assigned is: ' || v_jobnum);
  8  END;
  9  /
Your Job Number assigned is: 42

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> --








Related examples in the same category

1.Simple Procedure with SUBMIT
2.Using the SUBMIT Procedure
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