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