zengxia0527的博客

use [msdb] declare @job_name varchar(100) set @job_name = N’DBbak’ –要删除的作业名称 –删除在计划里面的日志 delete sysmaintplan_log from sysmaintplan_subplans as subplans inner join sysjobs_view as syjobs on subpl

USE [Database] GO /* Object: StoredProcedure [dbo].[P_DBbakjob] Script Date: 05/27/2017 15:15:57 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GOALTER proc [dbo].[P_DBbakjob]