Subject | RE: [firebird-support] Re: Performance of the count Function. |
---|---|
Author | Nigel Weeks |
Post date | 2005-02-28T23:08:15Z |
> Is there a scheduler planned for FB, or maintaining this another jobA scheduler is easy! You've already got one!
> for an isql script in the windows scheduler or service sitting on the
> server?
crontab entry on Unix/Linux:
# Every hour, run a query
0 * * * * /usr/local/scripts/do_something.sh
and in that 'do_something.sh' file, we have:
/opt/firebird/bin/isql -u sysdba -p masterkey <
/usr/local/scripts/do_something.sql
And in that 'do_something.sql' (Note the .sql, not the .sh)
select 'Hello!' from rdb$database;
In windows, just use the 'scheduled tasks' system to launch a .bat file,
that launches 'isql' with a file full of sql commands.
Very easy, and very maintainable.
N