Examples
- To delete audit entries or statistical data of process instances for template IDs 1, 3, 5, and 7, (= ec_proc_template.id) that have completed, cancelled, or failed before the specified date:
EXEC amxbpm.ec_delete_audit_stats_data '1, 3, 5, 7', '08-OCT-10 13:35:37’
- To delete audit entries of process instances for all templates completed, cancelled, or failed before the specified date:
EXEC amxbpm.ec_delete_audit_stats_data NULL, '08-OCT-10 13:35:37’
- To delete all audit entries of process instances for template IDs 1, 3, 5, and 7 (= ec_proc_template.id):
EXEC amxbpm.ec_delete_audit_stats_data '1, 3, 5, 7'
- To delete audit entries for all completed, cancelled, or failed process instances:
EXEC amxbpm.ec_delete_audit_stats_data
- To delete audit entries of process instances for all templates completed, cancelled, or failed before the specified date, with debug switched on:
EXEC amxbpm.ec_delete_audit_stats_data NULL, '08-OCT-10 13:35:37’, NULL, 'TRUE'
- To delete audit entries for all completed, cancelled, and failed process instances with a different commit batch size (for example, 150):
EXEC amxbpm.ec_delete_audit_stats_data NULL, NULL, 150
- To delete audit entries for all completed, cancelled and failed process instances with a different cursor refresh size (for example, 2000):
EXEC amxbpm.ec_delete_audit_stats_data NULL, NULL, NULL, 2000
Copyright © Cloud Software Group, Inc. All rights reserved.