Re: dbms_job

Bear in mind, also, that to get the job to start running, you must enter a Commit, after submitting the job.

This is because the job is written to the SYS.JOB$ table.

-- 
Regards

Jason
+-------------------------------------+
| Jason Pepper                        |
|                                     |
| jason_at_steamer.u-net.com             |
|                                     |
| www.steamer.u-net.com               |
|                                     |
+-------------------------------------+

Jurij Modic <jurij.modic_at_mf.sigov.mail.si> wrote in article
<336F5ED0.B4A437B2_at_mf.sigov.mail.si>...


> 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       !

>  ===============================================================

> 

>