Subject Re: [firebird-support] Firebird to periodically execute a stored procedure
Author Anderson Farias

> I am using FB 2.1 Superserver on the Windows platform. I am trying to
> find the most elegant way to get the Firebird server to periodically
> run a stored procedure (e.g every hour). I don't want to rely on any
> external application to periodically invoke the stored procedure.

An option is to use ISQL to execute an SQL script and Windows Task Scheduler
to periodicaly run ISQL, ex:

create some SQL script like, proc.sql:

execute procedure some_proc;

Use Windows Task Scheduler to schedule a task like:

isql servername:dbname -i proc.sql -user <user> -pass <pass>

(you may use a .bat script for that)

Anderson Farias