Displays the profile of a specified agent. This stored procedure is executed at the Distributor on any database.
sp_help_agent_profile
sp_help_agent_profile [ [ @agent_type = ] agent_type ]
[ , [ @profile_id = ] profile_id ]
|
Value |
Description |
|---|---|
|
1 |
Snapshot Agent |
|
2 |
Log Reader Agent |
|
3 |
Distribution Agent |
|
4 |
Merge Agent |
|
9 |
Queue Reader Agent |
use <DistirbutorDatabaseName> GO sp_help_agent_profile @agent_type=2 GO
