Re: Daily SQL Update Statement Execution

From: Brian W. Chester <bwchester_at_home.com>
Date: Wed, 15 Mar 2000 14:12:28 GMT
Message-ID: <gTMz4.16858$a27.265599@news1.rdc1.mb.home.com>

Marty,

Read up on DBMS_JOB. This will allow you to schedule events within Oracle.

Brian

"Marty Provost" <mprovost_at_liquidgolf.com> wrote in message news:v4Mz4.1256$kv6.71320_at_newsread1.prod.itd.earthlink.net...
> I need to run an update sql statement once a day. How can I automate
this?
> I am familiar with how to schedule an OS command file/batch file but I
don't
> know how to make a sql statement an OS executable file.
>
> On the flip side, I looked at making a trigger but I don't know how to
> schedule the trigger to run daily, not based on another sql statement.
>
> Thanks in advance for you help.
>
> Marty
>
>
Received on Wed Mar 15 2000 - 08:12:28 CST