-- delete sql agent job history for named job EXEC msdb.dbo.sp_purge_jobhistory @job_name = N'data load' ; -- delete sql agent job history for named job, with date parameters EXEC dbo.sp_purge_jobhistory @job_name = N'data load', @oldest_date = '2008-12-31' -- delete all sql agent job history EXEC msdb.dbo.sp_purge_jobhistory
No comments:
Post a Comment