The SET_PURGE_JOB_STATUS procedure enables or disables the specified purge job.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_AUDIT_MGMT.SET_PURGE_JOB_STATUS(
audit_trail_purge_name IN VARCHAR2,
audit_trail_status_value IN PLS_INTEGER) ;
Parameters
| Parameter | Description |
|---|---|
| audit_trail_purge_name | The name of the target purge job, which is created by using the CREATE_PURGE_JOB procedure. |
| audit_trail_status_value | Valid values:
|
Examples
The following example calls the SET_PURGE_JOB_STATUS procedure to enable the purge job named MyCLEANUP:
BEGIN
DBMS_AUDIT_MGMT.SET_PURGE_JOB_STATUS(
audit_trail_purge_name => 'MyCLEANUP',
audit_trail_status_value => DBMS_AUDIT_MGMT.PURGE_JOB_ENABLE);
END;