Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hthikey
Starting Member
4 Posts |
 Posted - 2007-08-22 : 09:08:56
|
| Hi,I created and scheduled a test snapshot publication and a push subscription using the sql server replication wizard. Tested it and it worked all fine as the data was regularly replicated to the destination server correctly. After I was satisfied with the test I deleted the replication and subscription without any problem. But I noticed that the jobs created by the replication wizard had not been deleted. I was disappointed as I had also expected these to be deleted because there are no more any local publication or replication on the server. I, then, tried to delete the job by right click - and then delete. But I am unable to delete the pubilcation and subscription jobs at all. When I try to delete the sql server 2005 the following error message appears:--start--------------------------------------------------------------------"Attempt to retrieve data failed for object for server <MYSERVER>" (Microsoft.SqlServer.Smo)Addional InformationThe job <jobname> does not exist on the server. (Microsoft.SqlServer.Smo)--End--------------------------------------------------------------------Can anyone help me on how to delete all replication jobs. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 15:07:00
|
| Did you refresh display in ssms? |
 |
|
|
|
|
|
Unable to delete a Replication Job in Sql Server