-- 12.03.2010 09:29:43: Script_1.log: Build started
-- 12.03.2010 09:29:44: Script_1.log: Build Completed
-- 12.03.2010 09:29:44: Script_1.log: Executing default description activity
-- 12.03.2010 09:29:44: Script_1.log: Variable "DEPOTID" set to "'0'"
-- 12.03.2010 09:29:44: Script_1.log: Variable value = '0'
-- 12.03.2010 09:29:44: Script_1.log: Variable "EMAIL" set to "'0'"
-- 12.03.2010 09:29:44: Script_1.log: Variable value = '0'
-- 12.03.2010 09:29:44: Script_1.log: Connecting to MPLS_DB2 (ELIX)
-- 12.03.2010 09:29:44: Script_1.log: Connection To: MPLS_DB2 (ELIX)
-- 12.03.2010 09:29:44: Script_1.log: Connection successful
-- 12.03.2010 09:29:44: Script_1.log: Connection logon: quentia
-- 12.03.2010 09:29:44: Script_1.log: Last schema: ELIX
-- 12.03.2010 09:29:44: Script_1.log: Default schema: ELIX
-- 12.03.2010 09:29:44: Script_1.log: Auto Commit: True
-- 12.03.2010 09:29:45: Script_1.log: Connection successful.
-- 12.03.2010 09:29:45: Script_1.log: Executing script: C:\Dokumente und Einstellungen\MRink\Desktop\Scripts\Automation Test\depot.sql
-- 12.03.2010 09:29:47: Script_1.log: Executed Statement
-- 12.03.2010 09:29:47: Script_1.log: Executed: SELECT * FROM ELIX.DEPOTLISTE where IS_IDS=1 and depotid='1000'
-- 12.03.2010 09:29:47: Script_1.log: Query returned 1 rows
-- 12.03.2010 09:29:48: Script_1.log: Script execution complete
-- 12.03.2010 09:29:48: Script_1.log: Begin loop dataset
-- 12.03.2010 09:29:48: Script_1.log: Executing activity Loop_row_1 using row 1
-- 12.03.2010 09:29:48: Script_1.log: Variable "DEPOTID" set to "DEPOTLISTE.DEPOTID"
-- 12.03.2010 09:29:48: Script_1.log: Variable value = 1000
-- 12.03.2010 09:29:48: Script_1.log: Connecting to MPLS_DB2 (ELIX)
-- 12.03.2010 09:29:48: Script_1.log: Connection To: MPLS_DB2 (ELIX)
-- 12.03.2010 09:29:48: Script_1.log: Connection successful
-- 12.03.2010 09:29:48: Script_1.log: Connection logon: quentia
-- 12.03.2010 09:29:48: Script_1.log: Last schema: ELIX
-- 12.03.2010 09:29:48: Script_1.log: Default schema: ELIX
-- 12.03.2010 09:29:48: Script_1.log: Auto Commit: True
-- 12.03.2010 09:29:49: Script_1.log: Connection successful.
-- 12.03.2010 09:29:49: Script_1.log: Executing script: C:\Dokumente und Einstellungen\MRink\Desktop\Scripts\Automation Test\delete_target.sql
-- 12.03.2010 09:29:51: Script_1.log: Executed Statement
-- 12.03.2010 09:29:51: Script_1.log: Executed: DELETE FROM LOGS.CHECK_RIGHTS WHERE DEPOT=':DEPOTID'
-- 12.03.2010 09:29:51: Script_1.log: Query returned 0 rows
-- 12.03.2010 09:29:53: Script_1.log: Script execution complete
-- 12.03.2010 09:29:53: Script_1.log: Executing script: C:\Dokumente und Einstellungen\MRink\Desktop\Scripts\Automation Test\export_records.sql
-- 12.03.2010 09:29:57: Script_1.log: Executed Statement
-- 12.03.2010 09:29:57: Script_1.log: Executed: SELECT * FROM  LOGS.CHECK_RIGHTS WHERE DEPOT=':DEPOTID' AND  TYPE!='OK' ORDER BY USR_NICKNAME,TYPE DESC
-- 12.03.2010 09:29:57: Script_1.log: Query returned 0 rows
-- 12.03.2010 09:29:59: Script_1.log: Script execution complete
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Adding Export Notification Subscriber 12.03.2010 09:29:59
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Export Started [12.03.2010 09:29:59]
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) ** START 12.03.2010 09:29:59
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Export Wizard: Building object list
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Build List 12.03.2010 09:30:03
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Exporting Data
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) BEGIN 12.03.2010 09:30:03 : Query
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Object SQL Query started.
-- 12.03.2010 09:30:07: Script_1.log: Thread (99) InternalReadBackground - start
-- 12.03.2010 09:30:07: Script_1.log: Thread (99) InternalReadBackground - after ExecuteReader - command SELECT * FROM  LOGS.CHECK_RIGHTS WHERE DEPOT=':DEPOTID' AND  TYPE!='OK' ORDER BY USR_NICKNAME,TYPE DESC 
-- 12.03.2010 09:30:07: Script_1.log: Thread (37) DoneReadTreadWriter
-- 12.03.2010 09:30:07: Script_1.log: Thread (37) Writing rows 1 - 0
-- 12.03.2010 09:30:07: Script_1.log: Thread (37) Writing rows Finalize
-- 12.03.2010 09:30:07: Script_1.log: Thread (37) DoneReadThreadWriter finally - adapter.RowsRead 0
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) END 12.03.2010 09:30:07 : Query
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Object SQL Query finished.
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) Export Finished [12.03.2010 09:30:07]
-- 12.03.2010 09:30:07: Script_1.log: Thread (30)   Build Time 00:00:04.0156250
-- 12.03.2010 09:30:07: Script_1.log: Thread (30)   Complete Time 00:00:08.2656250
-- 12.03.2010 09:30:07: Script_1.log: Thread (30) ** END 12.03.2010 09:30:07
-- 12.03.2010 09:30:07: Script_1.log: Executing script: C:\Dokumente und Einstellungen\MRink\Desktop\Scripts\Automation Test\usr.sql
-- 12.03.2010 09:30:09: Script_1.log: Executed Statement
-- 12.03.2010 09:30:09: Script_1.log: Executed: SELECT * FROM USRMGMT.USR WHERE USR_NICKNAME=':DEPOTID' FETCH FIRST ROW ONLY
-- 12.03.2010 09:30:09: Script_1.log: Query returned 0 rows
-- 12.03.2010 09:30:10: Script_1.log: Script execution complete
-- 12.03.2010 09:30:10: Script_1.log: Variable "EMAIL" set to "USR.USR_EMAIL1"
-- 12.03.2010 09:30:10: Script_1.log: Variable value = 
-- 12.03.2010 09:30:10: Script_1.log: Send email
-- 12.03.2010 09:30:10: Script_1.log: Email To: marc_rink@ids-logistik.de, From: marc_rink@ids-logistik.de, cc: 
-- 12.03.2010 09:30:10: Script_1.log: Email Subject: Mail for #DEPOTID# to email #EMAIL#
-- 12.03.2010 09:30:10: Script_1.log: Email message: Mail for #DEPOTID# to email #EMAIL#
-- 12.03.2010 09:30:10: Script_1.log: Setting up SMTP email
-- 12.03.2010 09:30:10: Script_1.log: Email Attachment: C:\Dokumente und Einstellungen\MRink\Desktop\Scripts\Automation Test\1000.xls