Hi Team,

ClusterandDBCleaner agent has been disabled in one of our environments but, we could still find the below mentioned deadlock query being generated during every midnight (~12 AM EST).JFYI, retention period DSS has been set to 1 day (unlike the default value “7” from below).

delete from DBO.pr_sys_statusdetails where pxUpdateDateTime < (select DATEADD(day, -7, CONVERT(DATETIME, DATEDIFF(dd, 0,max( pxUpdateDateTime)), 1)) from DBO.pr_sys_statusdetails ). frame procname=PEGA_IP.dbo.sppr_purge_table line=43 stmtstart=3028 stmtend=3120 sqlhandle=0x03000e002c337f14a31e2300f5a400000100000000000000000000000000000000000000000000000000000

What other OOTB agents or processes can exhibit this behavior ?

Please suggest.

Thank you.