The MSagent_profiles table contains one row for each defined replication agent profile. This table is stored in the msdb database.
|
Column name
|
Data type
|
Description
|
|---|
|
profile_id
|
int
|
The profile ID.
|
|
profile_name
|
sysname
|
The unique profile name for agent type.
|
|
agent_type
|
int
|
The type of agent:
1 = Snapshot Agent
2 = Log Reader Agent
3 = Distribution Agent
4 = Merge Agent
9 = Queue Reader Agent
|
|
type
|
int
|
The type of profile:
0 = System1 = Custom
|
|
description
|
nvarchar(3000)
|
The description of the profile.
|
|
def_profile
|
bit
|
Specifies whether this profile is the default for this agent type.
|
See Also