| Subject | Re: is there any way to setup a timer in database |
|---|---|
| Author | Adam |
| Post date | 2006-06-20T00:02:34Z |
--- In firebird-support@yahoogroups.com, "d_dude_2003"
<d_dude_2003@...> wrote:
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
Linux.
Simple.
Adam
<d_dude_2003@...> wrote:
>Write a SP to check the data whenever it is called.
> 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.
>
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
Linux.
Simple.
Adam