I am setup a new DB replication, during which I discover that there is no place to name the agent jobs for publisher, snapshot and subscriber, system wizard will name these jobs for me. But these name are ramdon and I wish they can be finalized before setup.
Is there any way to do this work?
I have tried, 1) rename them after setup, but it seems risky since internally replication will interact with these jobs through name. 2) Setup place holder jobs before replication setup, and let new jobs overwrite these jobs, it does not work as wished
and some of the job setting is not applied to new job.
Could any one help me out? And it will be great if your way can be done programmatically.
View Complete Post