-- 清除緩存
use [bcrf]
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1
GO

use [bcrf]
exec sp_replflush
GO

-- 刪除訂閱與發佈
use [bcrf]
exec sp_removedbreplication @dbname = 'bcrf' ,@type ='tran'
GO

---删除所有发布订阅相关job
USE [msdb]
GO

-- 声明一个游标来遍历所有匹配的作业
DECLARE job_cursor CURSOR FOR
SELECT name
FROM msdb.dbo.sysjobs
WHERE name LIKE 'MOSEVERPDC-bcrf-%';

-- 打开游标
OPEN job_cursor;

-- 声明变量来存储作业名称
DECLARE @JobName NVARCHAR(128);

-- 从游标中获取行
FETCH NEXT FROM job_cursor INTO @JobName;

-- 循环直到游标结束
WHILE @@FETCH_STATUS = 0
BEGIN
    -- 删除作业
    EXEC msdb.dbo.sp_delete_job @job_name = @JobName, @delete_unused_schedule = 1;

    -- 获取下一行
    FETCH NEXT FROM job_cursor INTO @JobName;
END;

-- 关闭并释放游标
CLOSE job_cursor;
DEALLOCATE job_cursor;
GO