Search: Go

Message Board

General

PL/SQL
Author Thread:How can we schedule the procedure to run automatically ?
Earl
How can we schedule the procedure to run automatically ?
Posted:Tuesday, October 04, 2005 3:06 PM (UMST)

Hi,

I need to schedule the procedure that i wrote to run automatically after certain amount of time. Is anybody knows how i can do this.

 

Thanks

Earl


 


Comments:

Author Thread:
arasu
How can we schedule the procedure to run automatically ?
Posted: Monday, September 18, 2006 11:22 PM (UMST)

Hi,

 

VARIABLE jobno NUMBER
BEGIN
   DBMS_JOB.SUBMIT(:jobno, 
      'your procedure name', 
       SYSDATE, 'SYSDATE + 1');
   COMMIT;
END;
/
PRINT jobno

you need to store the jobno.

by using the user_jobs, you can track.

 

hope this will help you

 

 

with regards,

arasu

 

Ferotech Solution Services Inc.