Displaying posts tagged with

“Remove Agent History”

Script to Remove Jobs History

Script to Remove Jobs History. You can remove jobs history for particular job for a fixed time. Below script will remove history data older then 30 days and where job name is “jobname”. I have used procedure “SP_PURGE_JOBHISTORY” provided by SQL Server, you just need to pass @JobName and @Date as a parameter. You can [...]