Subject Re: Daily triggers
Author homerjones1941
> just call your procedure from isql in a script run by cron (unix-based)
Thanks. You and Anderson suggested the same idea. I see a problem, however. Picture an end user thinking that if the scheduled job is good for one computer, it must be better for all network computers. In fact, the procedure should only be run once each day. We all know how "creative" end users can be. Apparently I need to make the procedure smart enough to only allow itself to be run once on any given day.

It would be nice if Firebird of the future would support something like that. It is difficult to influence user controlled things like scheduled tasks when the product is widely distributed.

Thanks for the suggestions.