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, and that do not have any active, detached sub-process instances:
    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 that completed, cancelled, or failed before the specified date, including data for any detached sub-process instances that are still active:
    EXEC amxbpm.ec_delete_audit_stats_data NULL, '08-OCT-10 13:35:37’, NULL, NULL, 'TRUE'
  • 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, NULL, 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