Re: Snapshot

Frederic Rivalland wrote:
>
> Hi
>
> I work with Oracle V7.0 and i am looking for a means to fire a
> stored procedures for example during the nigth but without USER ( like a
> deamon).
>
> I am using ,for instance, a Snapshot but i can t do any insert
> ,update, delete or execute procedure !!!
>
> Is there a means to do it (without using operating system
> (UNIX:cron)) ??
>
> thanks for your help.
>
> --
>
> ___________________________________________________________________
> frederic RIVALLAND
> frivalla_at_cri.univ-lr.fr
> La Rochelle

Hi Frederick,

Check out the DBMS_JOBS packaged procedure supplied with oracle in your $ORACLE_HOME/rdbms/admin directory. This sounds like it may suit your requirements.

Regards,

Sean Walters DBA Received on Wed Apr 17 1996 - 00:00:00 CEST