ALL RT tasks generate a LOG
ALL logs are always in the same Folder RTPathData & 'Logs\Tasks'
! PATH of the **DMC RT engine** ALWAYS read from REGISTRY ***DO NOT CHANGE***
DMC_RTPath = GETREG(REG_CURRENT_USER,'SOFTWARE\CGF\Data Management Center RT','Directory Installation')
! PATH of the DMC RT engine **DATA SUBFOLDER** ALWAYS read from REGISTRY ***DO NOT CHANGE***
DMC_RTPathData = GETREG(REG_CURRENT_USER,'SOFTWARE\CGF\Data Management Center RT','Directory Data')
! on a clean install the CU Key is not filled in by the RT installer
! read from LM Key which IS filled in by the RT Installer
IF ~DMC_RTPath
DMC_RTPath = GETREG(REG_LOCAL_MACHINE,'SOFTWARE\CGF\Data Management Center RT','Directory Installation')
DMC_RTPathData = GETREG(REG_LOCAL_MACHINE,'SOFTWARE\CGF\Data Management Center RT','Directory Data')
END
! DEFINE Final Full Path ***DO NOT CHANGE***
DMC_RTPathData = CLIP(DMC_RTPathData) & '\cgf_import\'
This is an example LOG created (from an SQL Backup task) :
12:04:33 --> (Drivers in machine = 46) - (DSN's in machine = 14)
!--------------------------------------------------------------------------------!
12:04:33 --> Data Transfer of Profile ID : 25 [1 / 1]
12:04:33 -->
12:04:33 --> Check Profile [ID = 25] (Profiles to process : 1)
12:04:33 --> Check Profile - Profile FOUND => WORK
12:04:33 --> (S) ODBC - MySQL - <=> (D) ODBC - MySQL -
12:04:33 --> Check ODBC - FOUND => Check Source Connection : Driver=MySQL ODBC 3.51 Driver;server=212.227.134.13;user=dmcrt_demo;pwd=**********;database=dmcrt_demo;port=3306;
12:04:33 --> Check ODBC - Check Source Connection
12:04:33 --> Check ODBC - Source Update Connection : SUCCESS
12:04:33 -->
12:04:35 --> SQL Backup (Profile : 25 [1 / 1] - Backup an SQL DB (scripts)) : START
12:04:37 --> SQL DB Backup => START (dmc_test)
12:04:37 --> SQL DB Backup => TOTAL Number of records to Process (550)
!--------------------------------------------------------------------------------!
12:04:51 --> SQL Backup Table (Hand Built) => START customer
12:04:51 --> SQL Backup Table (Hand Built) => OPEN Table customer
12:04:51 --> SQL Backup Table (Hand Built) => Records to Process = 294
12:04:56 --> SQL Backup Table (Hand Built) => CLOSE Table customer
!--------------------------------------------------------------------------------!
12:05:00 --> SQL Backup Table (Hand Built) => START personne
12:05:00 --> SQL Backup Table (Hand Built) => OPEN Table personne
12:05:00 --> SQL Backup Table (Hand Built) => Records to Process = 254
12:05:03 --> SQL Backup Table (Hand Built) => CLOSE Table personne
!--------------------------------------------------------------------------------!
12:05:03 --> SQL DB Backup => END (dmc_test) : Close ALL
12:05:03 -->
12:05:03 --> End of all Processes
All the logs can be read or retrieved from there very easily as they are all datetime stamped with a simply DIRECTORY command
You can add in your application some code to read this log file and display or FTP etc ....