Audit records can be applied to Asset Items automatically or manually. A SQL Scheduled Job is required if you would like the audits applied automatically to asset items.
More:
SQL 7.0 or 2000
SQL 2005