I have a very simple procdure that I want to run using dbms_job every, say, 30 sec. How would I accomplish it using dbms_job procedure. This is my procedure for printing name.
I want to know how to submit this print_name procedure to my dbms_job. Thanks.Code:
CREATE OR REPLACE PROCEDURE PRINT_NAME IS
DBMS_OUTPUT.PUT_LINE('MY NAME IS JOHNNY');