SQL SERVER 作业调度

use msdb

--创建作业
exec sp_add_job @job_name = job_Employee_Insert,
@enabled = 1,
@description = '每日11:30执行操作',
@start_step_id = 1,
@owner_login_name = sa

--添加由 sqlserveragent 服务执行的新作业
exec sp_add_jobserver @job_name = job_Employee_Insert
go

--创建作业调度
exec sp_add_jobschedule @job_name = job_Employee_Insert,
@name = '测试作业调度_Baiy',
@freq_type = 4,
@freq_interval = 1,
@active_start_time = 113000
go

--将一个步骤（操作）添加到作业中
exec sp_add_jobstep @job_name = job_Employee_Insert,
@step_name = bakdata,
@subsystem = tsql,
@command = 'exec sp_Employee_Insert' ,
@database_name=Baiy
go