Kjell,



There is a product called IBEXPERT. This product is an IDE but also has a set of command line utilities that allow you to perform scripting from a windows CMD shell. It is very powerful. It has functions for working with files, ftp servers, sending emails, etc.

Here is the link to their docs. http://ibexpert.net/ibe/index.php?n=Doc.IBEBlock.

Here is the link to send email… http://ibexpert.net/ibe/index.php?n=Doc.IbecSmtpSendMail , for working with ftp servers http://ibexpert.net/ibe/index.php?n=Doc.IbecFtpPutFile .



I HTH,



Edward Mendez







From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, August 15, 2017 9:36 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Automation tools?





Hi,

We're in need of a tool where we can author sequences of SQL queries against FB and non-DB commands like file operations etc. I'd like to call them "batch runs" to perform recurring tasks.

Do you know of such tools or what that kind of tool would be called in general?

We need to be able to schedule some runs. Others need to be triggered by e.g. the appearance of a file in a local or FTP/SFTP folder. Yet others need to be executed ad hoc, i.e. started manually.

We also need to be able to enter conditions/checks between each step, to check results, e.g. reasonable number of affected records, and bail out or at least send a warning e-mail message to me if something goes wrong or looks suspicious.

Regards,
Kjell

--



Kjell Rilbe
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

Marknadsinformation i Sverige AB
Ulvsundavägen 106C
168 67 Bromma
www.marknadsinformation.se <http://www.marknadsinformation.se>
08-514 905 90

<http://xn--fretagskontakt-vpb.se>
<http://personkontakt.se>







[Non-text portions of this message have been removed]