Skip to Content

SUP 2.x setting up Scheduled Tasks in Sybase Control Center

SUP 2.x setting up Scheduled Tasks in Sybase Control Center.

Purpose

This technical document explains how configure the four Sybase Control Center Scheduled Tasks
in order to keep SUP 2.x clean.

Required Software

     1. SUP 2.x.x or higher.

     2. SCC 3.x.

Assumption

This document assumes you have a working SUP environment.
You need to have access to the Admin role.
You need to understand each role the schedule task perform and their impact.

Issue 1 – Large logs and old logs:

a.SUP Server generates logs and will become stale over time.

Solution

Setup schedules Task cleanup to refresh the logs.

Step 1- Subscription Cleanup:

Is used for removing device user that no longer using the system. Use caution when enabling or
running this task. If an active user has not logged in within the time you schedule for the users
will be removed. Make sure all the users have connected and processed before running this task.
The task handles the devices differently for example.


Messaging based
Removes Subscription if unwired Server has not received a Synchronization message since
the given date in the schedule.

Replication based
Removes Subscription not used since the last Synchronization.

Lets get start with the configurations.

1.    Open the desktop icon for Sybase Control Center.

2.    Login ( default  user ID ): supAdmin.

3.    Password ( default password ): s3pAdmin (default).

4.    You should see the following screen below.

5.    Tree open Domains.

6.    Click on the default crown.

7.     Click on Scheduled Tasks tab.

                          

   Figure 1

8.    Place a check in Subscription Cleanup.

9.    Select Enable Button.

10.  Select Properties Button.

           Figure 2

11.  Select Schedule Tab.

12.  Days of the week click Select all button.

          Figure 3

13.  Select the Option Button.

14.  Number of inactive days add the number 120.

   Figure 4

  1. You are done setting up Subscription Cleanup.
  2. Click OK.

This complets the configuration for Subscription Cleanup.


Step - 2 Error History Clean up:

Is used for removing historical data on an MBO data refresh and operation replay failures
Caused by Network failures, System failures, user log in issues and back end data base issues.

  1. Place a check in the box for Error History Cleanup.
  2. Click Enable button.
  3. Click on the Properties Button.
  4. Select Schedule Tab.
  5. Days of the week select all Button.
  6. Click on the Options Tab.
  7. Number of days to preserve default 7.
  8. Click the OK button.

                 Figure 5

This complets the configuration for Error History Cleanup.

Step -3 Client Log Clean up:

Is used for removing client log records that have already been synchronized to the device and are
no longer associated with any active user.

  1. Place a check in the Client Log Cleanup.
  2. Click the Enable Button.
  3. Click the Properties Button.
  4. Select Schedule Tab.
  5. Days of the week select all Button.
  6. Click on the Options Tab.
  7. Number of days to preserve the log record the is default 7.
  8. Click on the OK Button.

               Figure 6

This complets the configuration for Client Log Clean up.

Steps – 4 Synchronization Cache Clean up.

Is used for removing logical deleted rows in the cache that are older than the oldest synchronization
time on a record in the system it also cleans up unused and stale partitions.  


1.         Place a check in the Synchronization Cache Cleanup.

2.         Click the Enable Button.

3.         Click the Properties Button.

4.         Select Schedule Tab.

5.         Days of the week select all Button.

7.         Click on the OK Button.

   Figure 7

You are done configuring the Synchronization Cache Cleanup.

Summary

This document explained in details about the steps needed to enable Schedule task.
Each task will help ensure the cleanup of old data that is no longer needed and keep the logs
to a manageable size.
There are other combinations you can take advantage of such as monthly,weekly and yearly
scheduling. Explore the other schedule option that may fit your needs and environment.

Tags: