Hi emel



It could be useful to run a SP on specified interval but.maybe that result
you expect can be achieved in different way!

What are you try to do running SP or trigger on every hour?



Regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of emel
Sent: 11 July 2008 19:27
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Firebird to periodically execute a
stored procedure

> > If I use OS feature, I loose a chance.
> > My software execute an SQL script and it don't know whitch OS run on
> > server ;)
>
> 1) The script can be run from a "remote" machine (not the one running your
> fb server)
> 2) The same aproach can be used on any OS, for instance in Linux you'd
> schedule using Cron
>
> Not a big deal as we're talking about a *server* task. (not a hundred
> workstations)

Misunderstanding !

If you can create a database trigger for periodically execute you don't
need manage the OS of server (for sheduler and isql start)! only your
database!!

Sufficient a database trigger then fired every minute (until database in
work, anybody connected).
Everybody can write our favourite sheduler for this ;)

eMeL





[Non-text portions of this message have been removed]