-- purge bulk operation data scheduled job
INSERT INTO BLC_SCHEDULED_JOB (ID, TYPE, TIMING_TYPE, NAME, ENABLED, EXECUTED, CRON,
MANAGE_IN_ADMIN, TRK_TENANT_ID, TRK_ARCHIVED, TRK_CHANGE_DETAILS)
VALUES ('PURGE_BULK_OPERATION_DATA', 'PURGE_BULK_OPERATION_DATA', 'CRON',
'Purge old Bulk Operations and Items', 'Y', 'N', '0 0 3 * * ? *', 'Y',
'5DF1363059675161A85F576D', 'N', '[]');
INSERT INTO BLC_SCHEDULED_JOB_DETAIL (JOB_ID, NAME, VALUE, VALUE_SHA, DETAILS_ORDER)
VALUES ('PURGE_BULK_OPERATION_DATA', 'purgeBulkOperationThreshold', '30d',
'dccf34aa1f3e476c3d6ebdb7fa90c2850c88570f', 0),
('PURGE_BULK_OPERATION_DATA', 'purgeBulkOperationBatchSize', '25',
'f6e1126cedebf23e1463aee73f9df08783640400', 1),
('PURGE_BULK_OPERATION_DATA', 'purgeBulkOperationItemBatchSize', '100',
'310b86e0b62b828562fc91c7be5380a992b2786a', 2),
('PURGE_BULK_OPERATION_DATA', 'purgeBulkOperationStatuses', 'COMPLETE',
'2c85a73cd12db61768b9bb19ea9828e95032a59a', 3);