SQL Server :如何在特定时间间隔后自动更新表中的数据

CREATE PROCEDURE UpdateData
AS
BEGIN
    UPDATE YourTable
    SET YourColumn = YourValue
    WHERE YourCondition;
END

EXEC msdb.dbo.sp_add_job
    @job_name = 'UpdateDataJob',
    @enabled = 1,
    @description = 'Job to update data in table',
    @category_name = 'Database Maintenance';

EXEC msdb.dbo.sp_add_jobstep
    @job_name = 'UpdateDataJob',
    @step_name = 'UpdateDataStep',
    @subsystem = 'TSQL',
    @command = 'EXEC UpdateData',
    @retry_attempts = 5,
    @retry_interval = 5;

EXEC msdb.dbo.sp_add_schedule
    @schedule_name = 'UpdateDataSchedule',
    @enabled = 1,
    @freq_type = 4, -- 每天
    @freq_interval = 1, -- 每隔1天
    @active_start_time = 080000; -- 开始时间为08:00:00

EXEC msdb.dbo.sp_attach_schedule
    @job_name = 'UpdateDataJob',
    @schedule_name = 'UpdateDataSchedule';

EXEC msdb.dbo.sp_add_jobserver
    @job_name = 'UpdateDataJob',
    @server_name = 'YourServerName';