The Notifier allows you to create custom SQL to program the server-initiated synchronization process. You do this by setting properties. For example, you would configure properties to perform tasks such as the following:
Set a polling interval using the poll_every property.
Create push requests in response to changes in the consolidated database. The begin_poll property is often used in this way.
Use the request_cursor property to determine what information is sent in a message, to whom, where, and when. The Notifier uses the result set returned by the request_cursor to send push requests to remote Listeners.
Note: The request_cursor property is the only required property. See request_cursor property.
Delete push requests with the request_delete property.
For a complete list of Notifier properties, see MobiLink Notification Properties.
For information about how to set Notifier properties, see Setting properties.
The following pseudo-code shows the sequence in which server-initiated synchronization properties are used. Note that except for request_cursor, all of these properties are optional.
connect_string isolation begin_connection poll_every For each poll ( begin_poll shutdown_query request_cursor For all requests expired before required confirmation ( error_handler ) request_delete end_poll ) end_connection