Re: dbms_job

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/05/06
Message-ID: <336F5ED0.B4A437B2@mf.sigov.mail.si>#1/1

Tom Hanstra wrote:

> I'm trying to use the dbms_job package without much luck. Does
> anyone have an example or two of how this package works?
>
> Thanks in advance. Please email replies.
>
> Tom Hanstra

There is an example in the dbmsjob.sql (script witch create dbms_job package).
But be aware that there is an error in a script!

• Begin quote from dbmsjob.sql: -- PROCEDURE submit ( job OUT BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE DEFAULT sysdate, interval IN VARCHAR2 DEFAULT 'null', no_parse IN BOOLEAN DEFAULT FALSE);
  • Submit a new job. Chooses JOB from the sequence sys.jobseq.
  • For example,
  • variable x number;
  • execute dbms_job.submit(:x,'pack.proc(''arg1'')',sysdate,'sysdate+1');

    ---

• End quote

This simple example lacks semicolon at the and of WHAT parameter. WHAT parameter should be: 'pack.proc(''arg1'');',

                            *

Replace the procedure name (and argument) with your own stuff and execute it.

--
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================

Received on Tue May 06 1997 - 00:00:00 CDT