BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
declare @myTime datetime
declare @myBak varchar(50)
set @myTime=getdate()
set @myBak='D:\BACKUP\DATA'
set @myBak=@myBak+convert(char(8),@myTime,112)
set @myBak=@myBak+cast(DATEPART(hh, @myTime) as varchar(2))
set @myBak=@myBak+cast(DATEPART(mi, @myTime) as varchar(2))
set @myBak=@myBak+cast(DATEPART(ss, @myTime) as varchar(2))
set @myBak=@myBak+'.bak'
select @myBak
/*backup database test to disk=@myBak*/
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1
EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'
-- — 删除同名的警报(如果有的话)。
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'Test 备份')
/* IF (@JobID IS NOT NULL)
BEGIN
-- 检查此作业是否为多重服务器作业
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
WHERE (job_id = @JobID) AND (server_id <> 0)))
BEGIN
-- 已经存在,因而终止脚本
RAISERROR (N'无法导入作业“Test 备份”,因为已经有相同名称的多重服务器作业。', 16, 1)
GOTO QuitWithRollback
END
ELSE
-- 删除[本地]作业
EXECUTE msdb.dbo.sp_delete_job @job_name = N'Test 备份'
SELECT @JobID = NULL
END
*/
BEGIN