AX 2012 R3 Query to Find the Jobs which are in stuck state and need to cancel them to clear up the download session.
--Query to Find out how many Jobs are not applied as per current date and got into stuck status
Select * from RetailCDXDownloadSessionDataStore where status!=4 and CREATEDDATETIME not between '2018-11-30 00:00:00.000' and '2018-11-30 23:59:59.000'
--- Query to Cancel the Old not applied Job----
update RetailCDXDownloadSessionDataStore set status=5 where status!=4 and CREATEDDATETIME not between '2018-11-30 00:00:00.000' and '2018-11-30 23:59:59.000'
--Query to Find out how many Jobs are not applied as per current date and got into stuck status
Select * from RetailCDXDownloadSessionDataStore where status!=4 and CREATEDDATETIME not between '2018-11-30 00:00:00.000' and '2018-11-30 23:59:59.000'
--- Query to Cancel the Old not applied Job----
update RetailCDXDownloadSessionDataStore set status=5 where status!=4 and CREATEDDATETIME not between '2018-11-30 00:00:00.000' and '2018-11-30 23:59:59.000'
