Implemetation for 1345_Mediaset:
TOC
1) Management Studio: Run SCTE104_LOG_TABLE.sql in the LOG Database of TOC. This script will create the log table
dbo.SCTE104_LOG and the SP dbo. SCTE104_LOG_DeleteOldRecord required to delete old records
2) In the Etere.Toc104.exe insert the name of LOG Database:
Parameters_TOC
3) In the Etere.Detect104.exe insert the IP Address of the Inserter. Leave empty if the IP is the same:
Parameters_TOC_02
COLOGNO
1) Run Database maintenance to create the log table dbo.SCTE104_LOG and the SP dbo. SCTE104_LOG_DeleteOldRecord
required to delete old records
2) In the settings assign the station code:
Schedule_Parameters_TOC_02
_____________________________________________________________________________________________________________________
1) In the table dbo.SCTE104_LOG the field ID_Rete has been removed (it is no longer needed).
2) The procedure dbo.SCTE104_LOG_DeleteOldRecord needs a parameter that indicates the number of days to delete the
oldest rows. The following example deletes all rows older than 30 days:
Exec dbo.SCTE104_LOG_DeleteOldRecord 30