I am trying to generate a scipt to rename the replication distribution agent jobs using the MSDistribution_agents table. I have found a way to rename the snapshot jobs on the Publisher based on the information stored in the job_id field in
the MSsnapshot_agents table and I was hoping to do the same for the distribution jobs using the job_id and the information stored in the MSDistribution_agents table.
The problem is that the distribution agents are running on a different database on a different box and there is no way that I can associated the job_id in the MSDistribution table with any of the job_ids in the msdb.sysjobs on the remote server.
Can anyone tell me if the job_id stored in the MSdistribution_agents table corresponds to any of the objects on the remote servers? I need to do this on more than 6 servers so it is very tedious trying to manually rename the jobs everytime I have to fix/setup
Thanks in advance for looking at this
View Complete Post