Re: Daily SQL Update Statement Execution

From: <gmei_at_my-deja.com>
Date: Wed, 15 Mar 2000 14:30:07 GMT
Message-ID: <8ao6p9$lck$1@nnrp1.deja.com>

In article <v4Mz4.1256$kv6.71320_at_newsread1.prod.itd.earthlink.net>, "Marty Provost" <mprovost_at_liquidgolf.com> wrote:
> 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
>

You can put your update sql statement in a file (say: myUpdate.sql), and then use cron job to execute "myUpdate.sql"
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 08:30:07 CST