From: Lun Wing San <wslun@hkpc.org>
Subject: Re: DBMS_JOB example
Date: 1996/11/11
Message-ID: <32875F7D.2C5A@hkpc.org>#1/1
references: <561oqt$o9d@newton.pacific.net.sg>
to: N Prabhakar <prabhs@po.pacific.net.sg>
content-type: text/plain; charset=us-ascii
organization: Lun's Oracle Solution Company
mime-version: 1.0
reply-to: wslun@202.70.22.8
newsgroups: comp.databases.oracle
x-mailer: Mozilla 3.0 (Win16; I)



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@hkpc.org
Telephone   : 852-2788-5841