[ @plan_id = ] 'plan_id'指定要删除的维护计划的 ID。 @plan_id 是uniqueidentifier,并且必须是有效的 ID。返回代码值0(成功)或 1(失败)。注解sp_delete_maintenance_plan 必须从 msdb 数据库运行。权限可以授予 EXECUTE 此过程的权限,但在 SQL Server 升级期间可能会重写这些权限。
從維護計劃中移除最後一個資料庫時sp_delete_maintenance_plan_db,預存程式也會刪除維護計劃。 權限 您可以授與此EXECUTE程序的許可權,但這些許可權可能會在 SQL Server 升級期間覆寫。 範例 刪除資料庫中先前使用sp_add_maintenance_plan_db新增的AdventureWorks2022維護計劃。
sp_delete_maintenance_plan [ @plan_id = ] 'plan_id' 参数 [@plan_id =]'plan_id' 指定要删除的维护计划的 ID。lan_id的数据类型为uniqueidentifier,并且必须是有效 ID。 返回代码值 0(成功)或 1(失败) 注释 必须在msdb数据库中运行sp_delete_maintenance_plan。
-- Maintenance plan cleanup for SQL 2005. -- If this job came from another server and it runs a subplan of a -- maintenance plan, then delete the subplan record. If that was -- the last subplan still referencing that plan, delete the plan. -- This removes a distributed maintenance pla...
-- Maintenance plan cleanup for SQL 2005. 1. -- If this job came from another server and it runs a subplan of a 1. -- maintenance plan, then delete the subplan record. If that was 1. -- the last subplan still referencing that plan, delete the plan. ...
You may get below error while trying to delete Maintenance Plan after server name change: - TITLE: Microsoft SQL Server Management Studio Exception has been thrown by the target of an invocation. (mscorlib) ADDITIONAL INFORMATION: An error was encountered when trying to remove the p...
there are multiple ways to delete the old backups files in SQL Server Check this post for multiple options including the use of the maintenance plan wizard https://ariely.info/Blog/tabid/83/EntryId/328/SQL-Server-Delete-old-backup-files-including-undocumen... ...
I am on the SQL Server using SQL 2014 Management Studio. I have a bigger problem. I noticed I can't delete nor change any of the maintenance plans at all. If I change a plan, it reverts back to its original settings. I have full admin sql rights. ...
Delete old database backup files automatically in SQL Server using SQL Server Maintenance plan: SQL Server Maintenance plans are another way of deleting old backup files by using the cleanup task. When connected to the server, expand it and theManagementfolder after. Then right click onMaintena...
public void DeleteCacheRefreshPlanAsync (string CacheRefreshPlanID); 参数 CacheRefreshPlanID String 适用于 SQL Server .NET SDK 2016 产品版本 SQL Server .NET SDK 2016 DeleteCacheRefreshPlanAsync(String, Object) C# 复制 public void DeleteCacheRefreshPlanAsync (string Cac...