Integration Guide
Table Of Contents
- I
- Introduction
- Architecture Overview
- Hardware Requirements
- PSS Software Installation
- Install NT 4.0 Server
- Install the NT 4 Service Pack
- Install Internet Explorer 4.01 Service Pack 2
- NT Option Pack Install
- Install the Video Driver
- Create and Format the Database partition
- Desktop Cleanup (optional)
- Install Microsoft SQL Server 7
- Create and Configure the PSS Database
- Install Microsoft Access
- Internet Explorer 5.0 with Task Scheduler install
- Install WaveWorks
- Install PSS Runtime System
- Install Waveworks Development Studio
- Install PSS Development System
- TFTP Configuration
- DHCP Configuration
- Create an ODBC Data Source
- Load Initial Data
- MS IIS Configuration
- Obtaining Access to PSS System Administration Screens
- Configure Task Scheduler
- Configure Unit Management
- Configure Licensing
- Configure the NBQMAIN Service (IBM 4690 POS Only)
- Setup NT System Log
- Configuration of the PSS System
- Validation of System Operation
- Directory Listing of PSS Folders/Files
- Software Description
- _
- Hardware Overview
- Software Components
- Database Access
- Start of Shopping Trip Processing
- Shopping Trip Processing
- End of Shopping Trip Processing
- Shopping Trip Message Log Entries
- Fatal Messages:
- PSSTransactionFile Processing
- POS Transaction File Processing
- Item Record File Processing
- Customer Update File Processing
- PSS Services
- _
- Customizing the PSS System Software
- Custom DisplayServer Scripts
- Custom Services
- Custom Business Objects
- User Exit DLL
- Available User Exit Functions
- UE_PreProcessItemFile
- UE_PreProcessItemRecord
- UE_PostProcessItemRecord
- UE_PostProcessItemFile
- UE_PreProcessTaxFile
- UE_PostProcessTaxFile
- UE_PreProcessPOSTransFile
- UE_PreProcessPOSTransRecord
- UE_PostProcessPOSTransRecord
- UE_ProcessEODRecord
- UE_PostProcessPOSTransFile
- UE_PreProcessPSSTransFile
- UE_PreProcessPSSTransRecord
- UE_PostProcessPSSTransFile
- UE_CalculateItemPrice_Method10to20
- UE_RescanLevelCalculation
- UE_Pre-RescanDetermination
- UE_PostRescanDetermination
- UE_PreProcessMarketingMessage
- UE_LoginAuthorization
- System Administration Interface
- Specific Features
PSS Software Installation
______________________________________________________________________________
WaveWorks PSS, Integration Guide, 1.10 Page 30
© 2000, Symbol Technologies, Inc. February 1, 2000
4.9.3 Configure the Clear Transaction Log job
This step will schedule a clearing of the SQL Server Transaction Log, which provides temporary
space for all data modification activities in the database. The Transaction Log must be cleared
occasionally to remove old inactive database transaction entries.
- Under SQL Server Agent, click on ‘Jobs’.
- In the right pane, right-click, and select ‘New Job...’
- General tab:
- In Name, enter 'Clear Transaction Log'.
- Under Category, select 'Database Maintenance'.
- Steps tab:
- Click New...
- In Step name, enter 'Clear Transaction Log'.
- Under Database, select the name of the PSS database.
- In Command, enter 'BACKUP TRANSACTION <dbname> WITH
TRUNCATE_ONLY, where <dbname> is the name selected under the Database
field.
- Press OK.
- Schedules tab:
- Press New Schedule...
- In Name, enter 'Every 2 hours' (or if you decide to use a different recurrence, a
similarly descriptive name)
- Make sure Recurring is selected, and press Change...
- In Occurs, press Daily.
- In Daily Frequency, select Occurs Every, and change the value to the right to
2.