Просто из Management Studio не удаляются. ну да ладно, пойдем тру путем...
SELECT NAME, ID FROM MSDB..SYSMAINTPLAN_PLANS
Every week backup gdata 1291B78A-E98A-46CD-B637-82CD0DFC0E72
Every month backup gdata 5D38C047-1F50-48CF-8063-663273D07960
Every week backup fdata 339CF3FA-2240-4D6E-80D0-BBB091B056C3
Every month backup fdata 46EF3C82-27AC-4159-A3EF-5C966B1B649D
Every day system data backup 76EB2AA6-7F08-434E-819B-61071BBA0C6A
Ок, давайте грохнем.
DELETE FROM SYSMAINTPLAN_SUBPLANS WHERE PLAN_ID = [color=red]'1291B78A-E98A-46CD-B637-82CD0DFC0E72'[/color]
пойдите нахрен, (0 row(s) affected)
Updated: 19 February 2015, 18:17:04
Сорри, всё нормально, был напуган, извините...
Просто лучше сразу так.
DELETE FROM SYSMAINTPLAN_LOG WHERE PLAN_ID='1291B78A-E98A-46CD-B637-82CD0DFC0E72'
DELETE FROM SYSMAINTPLAN_SUBPLANS WHERE PLAN_ID = '1291B78A-E98A-46CD-B637-82CD0DFC0E72'
DELETE FROM SYSMAINTPLAN_PLANS WHERE ID = '1291B78A-E98A-46CD-B637-82CD0DFC0E72'
Updated: 19 February 2015, 19:19:39
Отлично, теперь висят джобы кривые...
USE [msdb]
GO
/****** Object: Job [0] Script Date: 02/19/2015 19:16:15 ******/
EXEC msdb.dbo.sp_delete_job @job_id=N'7879a83b-af3c-4867-97ec-c952791373b3', @delete_unused_schedule=1
GO
Msg 547, Level 16, State 0, Procedure sp_delete_job, Line 178
The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column 'job_id'.
The statement has been terminated.
Updated: 19 February 2015, 19:22:10
Второй кривой джоб даже скрипта собрать на себя не может.
Attempt to retrieve data for object failed for Server 'BIG\SQL2005'. (Microsoft.SqlServer.Smo)
The Job 'MaintenancePlan.Subplan_1' does not exist on the server. (Microsoft.SqlServer.Smo)
Updated: 19 February 2015, 19:34:08
use msdb
Select * from sysmaintplan_subplans
смотрим id и валим
Delete from sysmaintplan_subplans
Where plan_id = '4CECDFC9-4593-402A-8EFC-15AE275BA69C'
Не помогло...
Updated: 19 February 2015, 19:52:32
Добил таки
select * from sysmaintplan_subplans
видим что кривой план зовется edbg
DELETE FROM sysmaintplan_log WHERE subplan_id in ( SELECT Subplan_ID from sysmaintplan_subplans WHERE subplan_name = 'edbg' )
DELETE FROM sysmaintplan_subplans WHERE subplan_name = 'edbg'