Unanswered: Replication - How to Change Job Names in Scripts?
I have been unsuccessful at changing job names in my replication scripts. I script replication including jobs, change the job names to follow our naming convention and then re-run the script. SQL Server creates my job names plus its own. For example, I see the following jobs for Distribution.
Database1atabase-1 (created by SQL Server)
REPL - Distribution - Database1 (The name I modified in the script)
If in EM I click on properties under Distribution Agent I find that the job created by SQL Server is the one being used, not mine. I am able to change the name of the job once it is created, but this is a pain.
What am I doing wrong?
Does everyone keep the default names created by SQL Server?