Posted: 11 Nov 2020 6:19 EST Last activity: 18 Nov 2020 1:37 EST
DELETE QUERIES @ pr4_log_rule_usage_details and pr_log_reportstats.
We observe the below mentioned DELETE Queries frequently. Are these from the ClusterandDBCleaner agent ? If yes, we have this agent enabled only at 12 AM EST, not sure why we observe these queries on regular basis.
Any chance that ClusterandDBCleaner agent although enabled on one JVM keeps running multiple times in a day ? Any known bugs related to this agent ?
Any idea that these queries can get triggered during JVM startups ?
(@P0 varchar(?),@P1 varchar(?))delete from dbo.pr4_log_rule_usage_details where pxObjClass = ?
and pxSystemNode = @P0
and pyLabel = @P1
delete from dbo.pr_log_reportstats where pxCreateDateTime < (
select DATEADD(day, -?, CONVERT(DATETIME, DATEDIFF(dd, ?,max( pxCreateDateTime)), ?))
from dbo.pr_log_reportstats )