Filter
Top Products
Chapter 14. Utilities and Options Reference
Agent exits.
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 re-
ceive phase of replication
exit code integer A non-zero exit code indicates an error.
Description If a procedure of this name exists, it is called as the last event before the
Message Agent shuts down.
sp_hook_dbremote_shutdown and sp_hook_ssrmt_shutdown
Function Use this stored 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 re-
ceive 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.
sp_hook_dbremote_receive_begin and sp_hook_ssrmt_receive_begin
Function Use this stored procedure to perform actions before the start of the receive
phase of replication.
Rows in #hook_dict None
sp_hook_dbremote_receive_end and sp_hook_ssrmt_receive_end
Function Use this stored procedure to perform actions after the end of the receive
phase of replication.
321