Subject | RE: [Firebird-general] Future release request |
---|---|
Author | Nigel Weeks |
Post date | 2004-09-29T06:50:48Z |
Or, by far the simpleset method is to use Window's 'Scheduled Tasks' system
to run a batch file, and in that batch file, have something like:
--- Start Batchfile Listing ---
"C:\Program Files\Firebird\Firebird 1.5\bin\isql.exe" -u username -p
password servername:c:/path/to/database.fdb < script.sql
--- End Batchfile Listing ---
And in the script.sql, have:
--- Start Script Listing ---
select * from end_of_month_process('2004-09-31');
--- Ene Script Listing
No new software, no bells, no whistles.
Just proven technology...
Nige.
-----Original Message-----
From: marius popa [mailto:mapopa@...]
Sent: Wednesday, 29 September 2004 4:23 PM
To: Firebird-general@yahoogroups.com
Subject: Re: [Firebird-general] Future release request
Myles Wakeham wrote:
www.cygwin.com
Community email addresses:
Post message: Firebird-general@yahoogroups.com
Subscribe: Firebird-general-subscribe@yahoogroups.com
Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
List owner: Firebird-general-owner@yahoogroups.com
Shortcut URL to this page:
http://www.yahoogroups.com/community/Firebird-general
Yahoo! Groups Links
__________ NOD32 1.880 (20040928) Information __________
This message was checked by NOD32 antivirus system.
http://www.nod32.com
to run a batch file, and in that batch file, have something like:
--- Start Batchfile Listing ---
"C:\Program Files\Firebird\Firebird 1.5\bin\isql.exe" -u username -p
password servername:c:/path/to/database.fdb < script.sql
--- End Batchfile Listing ---
And in the script.sql, have:
--- Start Script Listing ---
select * from end_of_month_process('2004-09-31');
--- Ene Script Listing
No new software, no bells, no whistles.
Just proven technology...
Nige.
-----Original Message-----
From: marius popa [mailto:mapopa@...]
Sent: Wednesday, 29 September 2004 4:23 PM
To: Firebird-general@yahoogroups.com
Subject: Re: [Firebird-general] Future release request
Myles Wakeham wrote:
> You can translate 'cron' to 'at' and it should have the same meaning to aor you can install cron that comes with cygwin tools :)
> Windows person. The Cron scheduler is similar to the AT scheduler built
> into Windows servers.
>
www.cygwin.com
Community email addresses:
Post message: Firebird-general@yahoogroups.com
Subscribe: Firebird-general-subscribe@yahoogroups.com
Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
List owner: Firebird-general-owner@yahoogroups.com
Shortcut URL to this page:
http://www.yahoogroups.com/community/Firebird-general
Yahoo! Groups Links
__________ NOD32 1.880 (20040928) Information __________
This message was checked by NOD32 antivirus system.
http://www.nod32.com