--- YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.
:CONNECT SQL2K12-SVR1

USE [msdb]
GO

/****** Object:  Job [ConfigDB Log Backup]    Script Date: 3/24/2012 7:12:47 PM ******/
EXEC msdb.dbo.sp_delete_job @job_name='ConfigDB Log Backup', @delete_unused_schedule=1
GO

USE [master]
GO
IF OBJECT_ID('BackupTransactionLogs') IS NOT NULL
BEGIN
	DROP PROCEDURE BackupTransactionLogs;
END
GO


:CONNECT SQL2K12-SVR2

USE [msdb]
GO

/****** Object:  Job [ConfigDB Log Backup]    Script Date: 3/24/2012 7:12:47 PM ******/
EXEC msdb.dbo.sp_delete_job @job_name='ConfigDB Log Backup', @delete_unused_schedule=1
GO

USE [master]
GO
IF OBJECT_ID('BackupTransactionLogs') IS NOT NULL
BEGIN
	DROP PROCEDURE BackupTransactionLogs;
END
GO

:CONNECT SQL2K12-SVR3
USE [msdb]
GO

/****** Object:  Job [ConfigDB Log Backup]    Script Date: 3/24/2012 7:12:47 PM ******/
EXEC msdb.dbo.sp_delete_job @job_name='ConfigDB Log Backup', @delete_unused_schedule=1
GO

USE [master]
GO
IF OBJECT_ID('BackupTransactionLogs') IS NOT NULL
BEGIN
	DROP PROCEDURE BackupTransactionLogs;
END
GO

:CONNECT SQL2K12-SVR4
USE [msdb]
GO

/****** Object:  Job [ConfigDB Log Backup]    Script Date: 3/24/2012 7:12:47 PM ******/
EXEC msdb.dbo.sp_delete_job @job_name='ConfigDB Log Backup', @delete_unused_schedule=1
GO

USE [master]
GO
IF OBJECT_ID('BackupTransactionLogs') IS NOT NULL
BEGIN
	DROP PROCEDURE BackupTransactionLogs;
END
GO

:CONNECT SQL2K12-SVR5
USE [msdb]
GO

/****** Object:  Job [ConfigDB Log Backup]    Script Date: 3/24/2012 7:12:47 PM ******/
EXEC msdb.dbo.sp_delete_job @job_name='ConfigDB Log Backup', @delete_unused_schedule=1
GO

USE [master]
GO
IF OBJECT_ID('BackupTransactionLogs') IS NOT NULL
BEGIN
	DROP PROCEDURE BackupTransactionLogs;
END
GO
