日志传送的~~-- 还原作业(每分钟一次)
EXEC msdb.dbo.sp_add_jobschedule
@job_id = @LS_Secondary_restore_job_id,
@name =N'LS_Restore_DB_LogShip_Test',
@enabled = 1,
@freq_type = 4,
@freq_interval = 1,
@freq_subday_type = 4,
@freq_subday_interval = 1,
@freq_recurrence_factor = 0,
@active_start_date = 19900101,
@active_end_date = 99991231,
@active_start_time = 0,
@active_end_time = 235900 EXEC msdb.dbo.sp_update_job --这儿为什么要调用啊?上边的@job_id和@enabled是一样的啊?
@job_id = @LS_Secondary_restore_job_id,
@enabled = 1
EXEC msdb.dbo.sp_add_jobschedule
@job_id = @LS_Secondary_restore_job_id,
@name =N'LS_Restore_DB_LogShip_Test',
@enabled = 1,
@freq_type = 4,
@freq_interval = 1,
@freq_subday_type = 4,
@freq_subday_interval = 1,
@freq_recurrence_factor = 0,
@active_start_date = 19900101,
@active_end_date = 99991231,
@active_start_time = 0,
@active_end_time = 235900 EXEC msdb.dbo.sp_update_job --这儿为什么要调用啊?上边的@job_id和@enabled是一样的啊?
@job_id = @LS_Secondary_restore_job_id,
@enabled = 1
能讲具体点吗??还是不懂~~! sp_add_shcedule是创建作业,sp_update_job是更改作业属性,调度属性是什么意思??谢啦~~!
sp_add_shcedule不是创建作业,而是创建作业的调度,指的是作业的发生频率,什么时候执行等等这些内容