Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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> --