Content

General description

Tango/04 Database Maintenance Job for T4EVENTLOG table.

Steps

Run the attached script into a SQL Server 2005 Query Analyzer, then a Job will be created in SQL Server Agent.

SQLJob

Solution

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 @HistoricalDatabaseName = 'B04_Events_Hst'
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.

Last Modified On: October 18, 2018