July 28, 2010 at 10:04 am
I am trying to customize a profile for snapshot agent, and add Deadlock parameter it, so application will not be locked during a snapshot. However following statement give me an error. Please advice, thanks.
EXEC sp_add_agent_parameter @profile_id = 17, @parameter_name = 'DistributorDeadlockPriority', @parameter_value = -1
Msg 21806, Level 16, State 1, Procedure sp_MSvalidate_agent_parameter, Line 63
The agent profile creation process cannot validate the specified agent parameter value: the profile_id 17 does not exist or it does not support the parameter -PublisherDeadlockPriority. The value must be an integer. Verify that replication is installed properly and that sp_add_agent_parameter is invoked with a valid value.
No Signature
August 2, 2010 at 2:29 pm
The @profile_id is the ID of the profile from the msagent_profiles table in MSDB.
The @profile_id specifies if it is a SnapShot Agent (1), Log Reader Agent (2), Distribution Agent (3), Merge Agent (4) and Queue Reader Agent (9). That is why your script fails when you give the profile_id as 17. It does not exist.
-Roy
August 3, 2010 at 12:44 pm
Thanks for reply. I manually added two parameters to replication meta table, and got my query through. However, I still couldn't see them from agent profile tab on replication monitor. I need to test it for confirmation.
BTW, I add a customized snapshot profile, which has profile_id 17.
No Signature
May 3, 2011 at 1:08 pm
Can you tell me if you got this to work or isn't the DistributorDeadlockPriority parameter availble in SQL Server 2005? Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply