Configuring Audit Trail Archive Retention

Archive Scheduling in MSSQL

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

  1. Access the Microsoft SQL Server and locate the Jobs folder in the Microsoft SQL Servers hierarchy.
  2. Open the archive using DBO entry.
  3. Click the Steps tab.
  4. Click the Edit button to edit the job.
  5. Edit the command to specify the new archive interval.
  6. 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.

See Also

Audit Trail

Activating Audit Trail

Deactivating Audit Trail

Viewing Audit Trail Activation History

Audit Trail Security

Audit Trail Search

Accessing the Audit Trail

Viewing Audit Trail Details

Viewing Audit Trail Attachments

Default Audit Trail Reports

Audit Trail Archiving

     

 

 
Wednesday, December 4, 2019
1:01 PM