1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
BEGIN TRY
BEGIN TRAN
DECLARE @jobId BINARY(16)
--Add job
EXEC msdb.dbo.sp_add_job @job_name=N'PurgeTS7Ans', @job_id = @jobId OUTPUT
--Add step to job
EXEC msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Requête à effectuer',
@step_id=1,
@subsystem=N'TSQL',
@command=N'DELETE FROM Action_OPE WHERE (DATEDIFF(dd, TimeStmp, GETDATE()) > 2558);',
@database_name=N'Bat_B1',
@flags=0
--Add schedule to job
EXEC msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'A_minuit',
@freq_type=1,
@freq_interval=4,
@freq_subday_type=1,
@freq_subday_interval=1,
@freq_relative_interval=0,
@freq_recurrence_factor=1,
@active_start_date=NULL,
@active_end_date=99991231,
@active_start_time=000000,
@active_end_time=235959
COMMIT TRAN
END TRY
BEGIN CATCH
SELECT ERROR_Message(), ERROR_Line();
ROLLBACK TRAN
END CATCH |
Partager