Call the ml_set_sis_sync_state system procedure in the publication_nonblocking_download_ack event to allow users to create a request_cursor event that references the ml_sis_sync_state table.

• publication_nonblocking_download_ack connection event

Specify a publication_nonblocking_download_ack event script with the following script to record the synchronization state:

CALL ml_set_sis_sync_state( 
    {ml s.remote_id},
    NULL,
    {ml s.publication_name},
    {ml s.username},
    NULL,
    {ml s.last_publication_download} 
);