Subject Re: is there any way to setup a timer in database
Author Adam
--- In, "d_dude_2003"
<d_dude_2003@...> wrote:
> Hi there folks,
> I need to run an automated check on the database data every minute or
> so. I thought maybe i can do this "inside" the database and then send
> out an event...So i dont have to query the db from client side...
> Any ideas?
> Thanks.

Write a SP to check the data whenever it is called.

Look at iSQL -i

Write a .sql script that calls this SP and commits (which will fire
the event), using iSQL to execute it. Write a batch file, and put that
batch file in the Windows Scheduler. Can also do same sort of thing in