sqlserver创建维护计划的脚本

以下是SQL Server创建维护计划的脚本示例：
USE [msdb]
GO

DECLARE @plan_id as varchar(50)
EXEC dbo.sp_add_maintenance_plan @plan_name=N'Maintenance Plan Test',@plan_id=@plan_id OUTPUT

DECLARE @subplan_id as varchar(50)
EXEC dbo.sp_add_subplan @plan_id=@plan_id,@subplan_name=N'Subplan1',@subplan_id=@subplan_id OUTPUT,@description=N'',@schedule_id=1,@replace=0

EXEC dbo.sp_add_maintenance_task @subplan_id=@subplan_id,@task_name=N'Backup Database Task',@description=N'',@task_id=@task_id OUTPUT,@subsystem=N'SQLSERVER',@command=N'BACKUP DATABASE [YourDatabaseName] TO DISK = N''C:\Backup\YourDatabaseName.bak'' WITH NOFORMAT, NOINIT, NAME = N''YourDatabaseName-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 10',@database_name=N'YourDatabaseName',@enabled=1,@frequency_type=4,@frequency_interval=1,@frequency_subday=0,@frequency_subday_interval=0,@frequency_relative_interval=0,@frequency_recurrence_factor=0,@active_start_date=20201210,@active_end_date=99991231,@active_start_time=0,@active_end_time=235959

EXEC dbo.sp_add_maintenance_plan_history @plan_id=@plan_id,@task_id= @task_id,@subplan_id=@subplan_id,@job_id=@job_id,@status=0,@operator_id_emailed=0,@operator_id_netsent=0,@last_run_outcome=0,@last_run_duration=0,@last_run_retries=0,@last_run_date=0,@last_run_time=0

这个脚本创建了一个名为“Maintenance Plan Test”的维护计划，其中包含一个名为“Subplan1”的子计划。子计划中包含一个备份数据库任务，该任务备份名为“YourDatabaseName”的数据库。备份文件将保存在“C:\Backup”文件夹中。备份任务将每天运行一次。