2

I'm trying to add the -Output parameter to my log reader agent for transactional replication and getting this error:

Msg 21805, Level 16, State 1, Procedure sp_MSvalidate_agent_parameter, Line 92
The agent profile creation process cannot validate the specified agent parameter value.
'K:\Inst06_TempDB\MSSQL10.INST06\MSSQL\Log\ReplOutput-LogReaderAgent.txt' is not a valid
value for the '-Output' parameter. The value must be an integer. Verify that replication
is installed properly and that sp_add_agent_parameter is invoked with a valid value.

http://msdn.microsoft.com/en-us/library/ms146878(v=SQL.100).aspx shows that -Output expects a path, not an integer as the error message says.

Pub & Sub are both v9.0.4211, Dist is v10.0.2723

My Script (run at distributor):

EXEC sp_change_agent_parameter @profile_id = 18
                              ,@parameter_name = '-Output'
                              ,@parameter_value = 'K:\Inst06_TempDB\MSSQL10.INST06\MSSQL\Log\ReplOutput-LogReaderAgent.txt'
EXEC sp_change_agent_parameter @profile_id = 18
                              ,@parameter_name = '-OutputVerboseLevel'
                              ,@parameter_value = '2' --[0|1|2|3|4] default 2
1

That link is for logread.exe. Checking the page for the stored procedure, see:

http://msdn.microsoft.com/en-us/library/ms190313%28v=SQL.100%29.aspx

I'm wondering if the hyphen is needed, as it is not listed like that on the stored procedure's page.

0

-OutputMessageFile instead of -Output.

reference:

USE msdb
GO
SELECT * 
FROM MSagentparameterlist;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.