Configuring Audit Trail Archive Retention

Archive Scheduling in MSSQL

Follow the steps below to change the schedule for audit trail archiving in MSSQL.

Access the Microsoft SQL Server and locate the Jobs folder in the Microsoft SQL Servers hierarchy.
Open the archive using DBO entry.
Click the Steps tab.
Click the Edit button to edit the job.
Edit the command to specify the new archive interval.
Click the OK button to exit.

Archive Scheduling in ORACLE

To change the schedule for audit trail archiving in Oracle, run the ActiveJob.sql script from the DBScripts\Oracle\AuditTrailArchive folder. Use the instructions contained in the comments within the script to set the archive schedule.