Lesson 4: Configuring the Notifier

In this lesson, you configure a Notifier event to define how the Notifier creates push requests, and sends push notifications to devices.

Prerequisites

This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up the consolidated database.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Configuring server-initiated synchronization using light weight polling.

Context and remarks

The request_cursor event script detects push requests. Each push request determines what information is sent, and which device should receive the information.

Task

In the left pane of Sybase Central under MobiLink 16, expand SIS_CarDealer_LP_DBLSN_CONDB_project, Consolidated Databases and then SIS_CarDealer_LP_DBLSN_CONDB - DBA.
Right-click Notification, and then click New » Notifier.
In the What do you want to name the new notifier field, type CarDealerNotifier.
Click Finish.
In the right pane, select CarDealerNotifier, and then click Properties.
Click the Events tab and click request_cursor from the Events list.

Type the following SQL statement in the provided text field:

SELECT ml_sis_sync_state.remote_id + '.sync' FROM ml_sis_sync_state
WHERE 
(
    EXISTS (SELECT 1 FROM Dealer
        WHERE last_modified >= ml_sis_sync_state.last_download)
    AND EXISTS (SELECT poll_key FROM non_sync_request)
)

Click OK to save the Notifier event.

Results

A Notifier is created and configured.

Next

Proceed to Lesson 5: Starting the MobiLink server.

Lesson 4: Configuring the Notifier

Task

See also