Tango/04 Database Maintenance Job for T4EVENTLOG table.
Run the attached script into a SQL Server 2005 Query Analyzer, then a Job will be created in SQL Server Agent.
1. Copy the attached script into a SQL Server 2005 or 2008 Query Analyzer
2. Before presh F5 (Running the script) you have to set the following variables from line 10 to 17:
SET @HistoricalDatabaseOwner = 'dbo'
SET @HistoricalDatabaseDays = '365'
SET @ProductionDatabaseName = 'B04_Events'
SET @ProductionDatabaseOwner = 'dbo'
SET @ProductionDatabaseDays = '7'
SET @TransactionSize = '5000'
SET @JobOwner = 'sa'
3. Run the Script (F5)
4. Go to SQL Server Agent -> Jobs -> Right click on Tango/04 Database Maintenance Job job -> Properties and Schedules. Then configure schedule time.
IMPORTANT: Keep SQL Server Agent service started after installing the Job.
Still have questions? We can help. Submit a case to Technical Support.