Sql server 定期备份数据，并删除某表

1.建个文件夹
2.建个作业


declare @Database nvarchar(256),@Path nvarchar(2048)
select @Database=N'MonitorDB',@Path=N'F:/MonitorDB_backup/'
declare @sql nvarchar(max)
select @sql =N'BACKUP DATABASE '+@Database+N'
TO  DISK = '''+@Path+@Database+N'_Full_'+REPLACE(REPLACE(REPLACE(convert(nvarchar(30),getdate(),126),'-','_'),':','_'),'.','_')+N'.bak''
WITH 
NOFORMAT, 
INIT,  
NAME = N''Full Database Backup'',
SKIP'
exec (@sql)


DELETE FROM [dbo].[Operate]