SQL SERVER作業調度

--建立作業
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