Displaying posts tagged with


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 [...]