When using SQL 4 CDS with Settings → Use Bulk Delete Operations enabled, SQL 4 CDS creates a Dataverse Bulk Delete System Job instead of executing synchronous delete operations. This works extremely well for large datasets and is much more reliable than long-running direct deletes.
However, the generated Bulk Delete System Job currently does not expose the Permanent Deletion option that is available when creating Bulk Delete jobs through the Dataverse UI.
Requested Enhancement
Add a new setting alongside:
Use Bulk Delete Operations
such as:
Use Permanent Deletion for Bulk Delete Operations
or
Permanent Delete (Bulk Delete Jobs)
When enabled, SQL 4 CDS would create Bulk Delete jobs with the Dataverse Permanent Deletion option selected.
Benefits
Faster execution of large delete operations.
Reduced cleanup time after environment refreshes.
Better support for Dev/Test/Sandbox environment maintenance.
Consistency with capabilities already available in the native Dataverse Bulk Delete UI.
Eliminates the need to manually edit or recreate Bulk Delete jobs after SQL 4 CDS generates them.
Desired Behavior
Optional SQL 4 CDS setting to enable Permanent Deletion on generated Bulk Delete jobs.
Default behavior remains unchanged for existing users.
Feature only applies when Use Bulk Delete Operations is enabled.
When using SQL 4 CDS with Settings → Use Bulk Delete Operations enabled, SQL 4 CDS creates a Dataverse Bulk Delete System Job instead of executing synchronous delete operations. This works extremely well for large datasets and is much more reliable than long-running direct deletes.
However, the generated Bulk Delete System Job currently does not expose the Permanent Deletion option that is available when creating Bulk Delete jobs through the Dataverse UI.
Requested Enhancement
Add a new setting alongside:
Use Bulk Delete Operationssuch as:
Use Permanent Deletion for Bulk Delete Operationsor
Permanent Delete (Bulk Delete Jobs)When enabled, SQL 4 CDS would create Bulk Delete jobs with the Dataverse Permanent Deletion option selected.
Benefits
Faster execution of large delete operations.
Reduced cleanup time after environment refreshes.
Better support for Dev/Test/Sandbox environment maintenance.
Consistency with capabilities already available in the native Dataverse Bulk Delete UI.
Eliminates the need to manually edit or recreate Bulk Delete jobs after SQL 4 CDS generates them.
Desired Behavior
Optional SQL 4 CDS setting to enable Permanent Deletion on generated Bulk Delete jobs.
Default behavior remains unchanged for existing users.
Feature only applies when Use Bulk Delete Operations is enabled.