JDE SSO with Azure AD with MFA

 

JDE SSO with Azure AD with MFA

SQL Server - Find Duplicate Submitted Jobs JDE

Find Duplicate Submitted Jobs JDE

WITH CTE(JCEXEHOST,JCFNDFUF2, duplicatecount)

AS (SELECT JCEXEHOST,JCFNDFUF2, ROW_NUMBER() OVER(PARTITION BY JCEXEHOST,JCFNDFUF2 ORDER BY  JCEXEHOST,JCFNDFUF2) AS DuplicateCount

    FROM SVM920.F986110 WHERE JCJOBSTS IN ('W') AND JCORGHOST='Enterprise_Server')

SELECT * FROM CTE WHERE DuplicateCount > 1;

Delete Duplicate Submitted Jobs JDE

WITH CTE(JCEXEHOST,JCFNDFUF2, duplicatecount)

AS (SELECT JCEXEHOST,JCFNDFUF2, ROW_NUMBER() OVER(PARTITION BY JCEXEHOST,JCFNDFUF2 ORDER BY  JCEXEHOST,JCFNDFUF2) AS DuplicateCount

    FROM SVM920.F986110 WHERE JCJOBSTS IN ('W') AND JCORGHOST='Enterprise_Server')

DELETE FROM CTE WHERE DuplicateCount > 1;