SQL Server创建任务计划脚本

最新推荐文章于 2024-06-24 09:56:11 发布

QQ75026717

最新推荐文章于 2024-06-24 09:56:11 发布

阅读量370

点赞数

分类专栏：随笔文章标签： sql

本文链接：https://blog.csdn.net/QQ75026717/article/details/111152314

版权

/****** Object: Job [任务名称] Script Date: 2020/12/11 10:30:18 /
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/ Object: JobCategory [[Uncategorized (Local)]]] Script Date: 2020/12/11 10:30:18 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N’[Uncategorized (Local)]’ AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N’JOB’, @type=N’LOCAL’, @name=N’[Uncategorized (Local)]’
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N’任务名称’,
@enabled=1,
@notify_level_eventlog=0,
@notify_level_email=0,
@notify_level_netsend=0,
@notify_level_page=0,
&#