sp_hook_dbremote_end

Function

Use this stored procedure to add custom actions just before the Message 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 receive 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.