patternMinor
Can you rename replication jobs?
Viewed 0 times
canyoureplicationjobsrename
Problem
I have snapshot replication running on three different servers, two publishers and one subscriber. The replication processes have associated jobs (either building the snap shot or grabbing the snap shot, I believe) that have ugly system-generated names. Is it safe to rename these something that's readable and understandable?
Solution
Yes you can rename the jobs. They will still function normally because they are identified by job_id for system purposes.
You can find more info about how it is uses in the MSdistribution_agents table. More info here: http://msdn.microsoft.com/en-us/library/ms174399(v=sql.90).aspx
You can find more info about how it is uses in the MSdistribution_agents table. More info here: http://msdn.microsoft.com/en-us/library/ms174399(v=sql.90).aspx
Context
StackExchange Database Administrators Q#17321, answer score: 4
Revisions (0)
No revisions yet.