Subject Re: [firebird-support] Re: Firebird to periodically execute a stored procedure
Author emel
> > 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