Re: DBMS_JOB example

N Prabhakar wrote:

> If I want to execute a job every 30 minutes, (this job is nothing but a
> stored procedure), how to do it.

In SQL*Plus or Server Manager:

   DBMS_JOB.SUBMIT(:jobno, 'proc(p1, p2, ..., pi);', SYSDATE, SYSDATE+1/48); You should declare the jobno as a variable with the datatype NUMBER and proc is the PL/SQL procedure name.

   Related Topics: Datatype, Server Manager

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841