Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Reference » SQL Remote utilities and options reference » SQL Remote system procedures

 

sp_hook_dbremote_shutdown system procedure

Use this system procedure to initiate a Message Agent shutdown.

Rows in #hook_dict table
Name Values Description

send

true or false

Indicates if the process is performing the send phase of replication.

receive

true or false

Indicates if the process is performing the receive phase of replication.

shutdown

true or false

This row is false when the procedure is called. If the procedure updates the row to true the Message Agent is shut down.

Description

If a procedure of this name exists, it is called when the Message Agent is neither sending nor receiving messages, and permits a hook-initiated shutdown of the Message Agent.