Click here to Skip to main content
15,889,877 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi every one,
Im new to oracle...i need to create a jobs inside the stored procedure..can u pls help..
Posted

1 solution

It is possible to submit a job using stored procedure.

SQL
CREATE OR REPLACE PROCEDURE DBMS_JOB_SUBMIT(PROC_NAME IN VARCHAR2)
IS
      INT_JOB_ID NUMBER := NULL;
BEGIN
      DBMS_JOB.SUBMIT (
         job => INT_JOB_ID,
          what => PROC_NAME || ';', -- What to run
          next_date => SYSDATE, -- Start right away
          interval => NULL -- Run only once
     );
     COMMIT;
END;
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900