March 3, 2008 at 2:32 pm
Had to migrate to new hardware running Server 2003, sql 2005, but keeping same server name. Databases, logins, two SSIS(DTS) packages working great. But, System and User maintenance plans failing since name change.
So, recreated them, and (with minor problem to be addressed at another time) the recreations are working fine. But, I can't delete (or modify) the old plans or jobs. Get the following error when physically sitting in front of the server logging in "Exception has been thrown by the target of an invocation(mscorlib). An error has occurred while establishing a connection to the server. When connecting to sql server 2005, this failure may be cause by the fact that under the default settings, sql server does not allow remote connecitons. (provider: tcp provider, error: 0 no such host is know) error 11001
As I said, I've disabled both jobs, but would prefer to delete the plan/jobs. But, it won't let me. Any ideas?
March 5, 2008 at 8:45 am
Found this and it worked like a charm - hope it helps someone else.
1. Select the ID with the select statement
select * from sysmaintplan_plans
2. Replace with the selected ID and run the delete statements
delete from sysmaintplan_log where plan_id = ''
delete from sysmaintplan_subplans where plan_id = ''
delete from sysmaintplan_plans where id = ''
3. Delete the SQL Server Jobs with the Management Studio
June 20, 2008 at 12:02 pm
It works, thank you!
November 7, 2008 at 8:53 am
Worked for me as well, thanks very much! This can't possibly be SOP for SQL 2005, can it?
November 3, 2009 at 10:38 am
Thank you very much this worked perfectly...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply