DECLARE @oldDate DATETIME
SET @oldDate = GETDATE()-30
EXECUTE MASTER.dbo.xp_delete_file
0,
N'D:\backup\',
N'bak',
@oldDate,
1
DECLARE @oldDate DATETIME
SET @oldDate = GETDATE()-30
EXECUTE MASTER.dbo.xp_delete_file
0,
N'D:\backup\',
N'bak',
@oldDate,
1
转载于:https://www.cnblogs.com/jenrrychen/p/7443540.html