EXEC sp_add_job @job_name = 'test',
EXEC sp_add_jobstep @job_name = 'test',
@step_name = 'test_1',
@subsystem = 'TSQL',
@command = 'update yourtable set yourcol=0',
@retry_attempts = 5,
@retry_interval = 5
EXEC sp_add_jobschedule @job_name = 'test',
@name = 'Schedule_test',
@freq_type = 16, -- daily
@freq_interval = 26,
@active_start_time = 10000
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货