Based on the customer feedback in the latest version of Advanced ETL Processor and Visual Importer ETL we have introduced Agent Email Notifications.
This option allows the controlling state of the repository connection.
For example, IT may decide to reboot the database server where the repository is hosted or
Repository database may run of disk space.
When the agent is up and running it is constantly checking repository connection, In case of failure, it will send an email notification and abort all tasks currently being executed.
Once the connection to the repository is reestablished agent will send another email and start executing scheduled tasks again
Example of Error Email:
Error Message: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation
Computer Name: COMPUTER
User Name: bill
Os Version: Windows 8.1 (Version 6.3, Build 9600, 64-bit Edition)
Number Of Threads: 11
Repository: MS SQL Server Repository
Type: MS SQL Server
Server: COMPUTER\SQLEXPRESS2008
Database: REPOSITORY
User: sa
Example of Reconnection Email
Error Message: Reconnected!
Computer Name: COMPUTER
User Name: bill
Os Version: Windows 8.1 (Version 6.3, Build 9600, 64-bit Edition)
Number Of Threads: 11
Repository: MS SQL Server Repository
Type: MS SQL Server
Server: COMPUTER\SQLEXPRESS2008
Database: REPOSITORY
User: sa
Example of Agent Log
Agent log is located in the same folder as the agent itself
