Subject | Re: [firebird-support] Re: Firebird to periodically execute a stored procedure |
---|---|
Author | emel |
Post date | 2008-07-11T16:27:07Z |
> > If I use OS feature, I loose a chance.Misunderstanding !
> > 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)
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