I have a distribution job that is failing on the first step : "Distribution Agent startup message"
The error in the job history is ...
Date 5/19/2011 12:30:01 AM
Log Job History (DIST MyPub)
Step ID 1
Job Name DIST MyPub
Step Name Distribution Agent startup message.
Sql Severity 16
Sql Message ID 2560
Operator Net sent
Retries Attempted 0
Executed as user:MyDomain\MyUser. Parameter 2 is incorrect for this DBCC statement. [SQLSTATE 42000] (Error 2560). The step failed
Parameter 2 is setting the Agent ID as ...
sp_MSadd_distribution_history @perfmon_increment = 0, @agent_id = 54, @runstatus = 1,
@comments = 'Starting agent.'
Obviously the Agent ID being passed is wrong.
How do I find the correct Agent ID for this particular distribution job so that I can change the "54" value with the correct Agent ID value?
View Complete Post