Couldn't add snapshot agent parameter.

  • 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

  • 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

  • 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

  • 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