Thursday, November 24, 2022

D365FO:Delete BatchJob History through SQL query

--delete from batchJobHistory where createdDateTime < '2020-12-31 16:00:49.000'

--DELETE    FROM batchHistory
--WHERE BatchJobHistoryId NOT IN
--    (SELECT RECID FROM batchJobHistory )

--DELETE    FROM constraintHistory
--WHERE DependsOnBatchId NOT IN
--    (SELECT RECID FROM batchHistory )

No comments:

Post a Comment

Table browser URL in D365FO

Critical Thinking icon icon by Icons8