restructure tss data 3.23 mtas like defrag for tss data run nightly or at least end of day once a week

restructure tss data 3.23 mtas like defrag for tss data run nightly or at least end of day once a week


This process should only be run when nobody is in TSS.

 

From the server computer down to the left of the time look for an icon first that looks like an upside-down V or the tip of an arrow.

Under the ^ look for the green IN icon then double click that icon it will open a window like

 


from there go to tools data management and do the third choice which is Restructure TSS Data 

It will ask you two questions are you sure you want to run the restructure you click yes.

Then it will ask if you want to stop the application server and you click yes to that and then it will go through and complete the process of running like the equivalent of a defragment for the TSS data. 

 

    • Related Articles

    • How do I run the end of day procedure in TSS XP?

      To run the end of day procedure in TSS go to the reports section, click on functions, then click on Run End of Day. The default end of day reports are as follows. Salesperson Profitability Report: This report subtotals by salesperson, showing the ...
    • Starting TSS XP Problems

      TSS XP has two components to it MTAS.exe and TSSXP.exe The MTAS.exe without it running and able to communicate through the firewall, TSSXP will not run The mtas program does lots of things two important things it does it controls updates from the ...
    • How can I add a report to the End of Day or End of Month procedure in TSS XP?

      Find the report you wish to add, highlight the desired report and change the criteria bottom of the screen. Run the report and then click report groups, then click add current report to end of day.
    • Backups in both TSS Plus and TSS XP

      TSS PLUS: Backups are easily created through the Database Maintenance Wizard when you click on the Ambulance icon in the bottom right of the TSS main menu. Select 'Manually Specify', click next and choose 'Backup Database Files', select the ...
    • how to set TSS Shortcut to run as admin automatically

      From The TSS shortcut right click go to Properties then go to compatability tab and check the box labelled run this program as an administrator