I'm trying to clean up the replication jobs on the server located under SQL Server Agent -> Jobs. However when I rename these jobs the replication monitor can't find them anymore.
When I select Merge Agent Job Properties from the Subscription Properties it throws the following error.
I'm renaming them by simply right clicking the job and selecting rename.
Yet if I rename the job to this big long assed string, [<servername>\<instance name>-<database name>- Unidirecti-<targetserver name>-43], Merge Agent Job Properties can find the job again.
How can I rename these jobs and avoid this error??
When I select Merge Agent Job Properties from the Subscription Properties it throws the following error.
TITLE: Replication Monitor
------------------------------
Replication Monitor could not display the Properties dialog box.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Attempt to retrieve data for object failed for Server '<servername>\<instance name>'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink...ct+Server&LinkId=20476
------------------------------
The Job '[<servername>\<instance name>-<database name>- Unidirecti-<targetserver name>-43]' does not exist on the server. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink...sNotExist&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I'm renaming them by simply right clicking the job and selecting rename.
Yet if I rename the job to this big long assed string, [<servername>\<instance name>-<database name>- Unidirecti-<targetserver name>-43], Merge Agent Job Properties can find the job again.
How can I rename these jobs and avoid this error??
