The SET_PURGE_JOB_INTERVAL procedure is used to set the runtime interval for a specified purge job, that is, to modify the execution frequency of a purge job created using the CREATE_PURGE_JOB procedure.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_AUDIT_MGMT.SET_PURGE_JOB_INTERVAL(
audit_trail_purge_name IN VARCHAR2,
audit_trail_interval_value IN PLS_INTEGER);
Parameters
Parameter |
Description |
|---|---|
| audit_trail_purge_name | Specify the name of the cleanup job for which you want to set the runtime interval.CREATE_PURGE_JOBThe name of the job to be cleared. |
| audit_trail_interval_value | Specifies the time interval for running the cleanup job, in hours. The value range is integers greater than 0 and less than 1000. |