Re: how to use DBMS_job?

From: Carl <sorry_at_no.email.address>
Date: 2000/08/07
Message-ID: <8mmjsr$mp3$1_at_taliesin2.netcom.net.uk>#1/1


"peter" <misybh_at_tpts7.seed.net.tw> wrote in message news:8mm7gi$rqe_at_netnews.hinet.net...
> hi..
> my XXX.fmx is placed on the server... I want to run this XXX.fmx
> at 3 p.m. everyday...can I use DBMS_JOB????
> how to set all parameter of DBMS_JOB??????
>
>
Peter,

I've never used DBMS_JOB, but as far as I'm aware it can only be used to run procedures and functions which have been stored in the database (e.g. in packages).
What O/S have you got on the server ?
In Unix you can use crontab, or on NT you can set up an 'AT' job (using the schedule service).
If you want to get really advanced, Oracle 8i has a new feature called PL/SQL external procedures : This means that a database process can call a C program on the server : Maybe the C program could then call the form ? This may be overkill though (crontab and AT are a lot simpler).

Carl. Received on Mon Aug 07 2000 - 00:00:00 CEST

Original text of this message