SSMS vs SQLAgent: "Automatically remove agent history" bugs
Through SSMS, the SQL Agent has a checkbox named "Automatically remove agent history." Once clicked, the user can set the number of days, weeks, etc.
There is not anything "automatic" about this feature.
From SQL Server 2005, it's issuing a one-time sp_purge_jobhistory @oldest_date, generating @oldest_date from a DateAdd(-1 * what you specified, getdate)
From SQL Server 2000, it returns the error "@oldest_date is not a parameter for procedure sp_purge_jobhistory."
https://connect.microsoft.com/SQLServer/feedback/details/172026/ssms-vs-sqlagent-automatically-remove-agent-history-bugs
Through SSMS, the SQL Agent has a checkbox named "Automatically remove agent history." Once clicked, the user can set the number of days, weeks, etc.
There is not anything "automatic" about this feature.
From SQL Server 2005, it's issuing a one-time sp_purge_jobhistory @oldest_date, generating @oldest_date from a DateAdd(-1 * what you specified, getdate)
From SQL Server 2000, it returns the error "@oldest_date is not a parameter for procedure sp_purge_jobhistory."
https://connect.microsoft.com/SQLServer/feedback/details/172026/ssms-vs-sqlagent-automatically-remove-agent-history-bugs
No comments:
Post a Comment