Hi,

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. The
store procedure performs some table cleanup for me.

Is there an elegant way to get the Firebird server to periodically
execute a stored procedure BY ITSELF without any external
intervention? The only workaround I thought of so far was to create a
trigger for the Transaction Start event: the trigger code would run
the stored procedure if the time elapsed since the last time it was
executed is > 1 hour. Any idea?

Thanks for your help,

Bruno