EXEC SP_ADD_JOBSCHEDULE @JOB_NAME = 'Northwind_BACKUP_LOG',
@NAME = 'Northwind_BACKUP_LOG' ,
@FREQ_TYPE = 4,
@FREQ_INTERVAL = 1,
@ACTIVE_START_TIME = 120000
GO
(其他代码省略)
上面只能在12:00 am 备份
怎样才能实现“每天的12:00 am和5:00 pm对northwind进行日志备份” ?
谢~
@NAME = 'Northwind_BACKUP_LOG' ,
@FREQ_TYPE = 4,
@FREQ_INTERVAL = 1,
@ACTIVE_START_TIME = 120000
GO
(其他代码省略)
上面只能在12:00 am 备份
怎样才能实现“每天的12:00 am和5:00 pm对northwind进行日志备份” ?
谢~
waitfor time '12:00'
EXEC SP_ADD_JOBSCHEDULE @JOB_NAME = 'Northwind_BACKUP_LOG',
@NAME = 'Northwind_BACKUP_LOG' ,
@FREQ_TYPE = 4,
@FREQ_INTERVAL = 1,
@ACTIVE_START_TIME = 120000
GO
@NAME = 'Northwind_BACKUP_LOG' ,
@FREQ_TYPE = 4,
@FREQ_INTERVAL = 1,
@ACTIVE_START_TIME = 120000
GOEXEC SP_ADD_JOBSCHEDULE @JOB_NAME = 'Northwind_BACKUP_LOG',
@NAME = 'Northwind_BACKUP_LOG' ,
@FREQ_TYPE = 4,
@FREQ_INTERVAL = 1,
@ACTIVE_START_TIME = 170000
GO