scheduling DB tasks (SP execution) on certain times

Hi,

I am trying to design some app for executing SP and maybe some other DB tasks on certian periods or moments of time - one choice is to make some app (Delphi e.g. with timer components) as desktop app or as windows service (what could be better choice?)... OK, but is there any inner features (some utility or smth like this) in FB how to schedule such tasks without application?

Thanks in advance

AFAIK Firebird does not have something like Oracle's dbms_job or MsSQL's SQLServerAgent, but there is no need to write a specific application, you can run your scripts through cron on *nix or windows scheduler.

Firebird doesn't have a job scheduler yet

you can use cron in linux , on windows i saw this utility
is only for backup
Maybe it gives you some ideas (is written in delphi)

http://www.talatdogan.com/fibs.htm

ps: i didn't tried yet

I don't understand why *nix guys love cron and windows guys always look for yet another scheduler application when you have one that comes with the OS.
BTW an internal scheduler in the database, which can be controlled through SQL is much better than any external tool, PostgreSQL development team just added PgAgent, which runs as an external service (like SQLServerAgent) but is controllable with queries from the database, hope Firebird will get this feature soon.

Yes, integrated scheduler would be great, but it will not be in Firebird in near feature...

I would like to suggest my tool xStarter FBIB to execute scripts at specified time in Firebird (Windows).