Recurring cleanup jobs

Application Security performs several cleanup jobs on a recurring basis. These are described in the following table.

Job name

 Description Affected tables Default schedule

Data Export Cleanup

Removes exported data (such as CSV files) that were more than the specified number of days old (see Configuring job scheduler settings).

dataexport

documentinfo

datablob

Daily at 23:45 h

For instructions on how to schedule this job, see Configuring job scheduler settings.

Event Log Cleanup

 Removes event records older than the number of days specified on the Scheduler page. eventlogentry

Daily at 23:30 h

For instructions on how to schedule this job, see Configuring job scheduler settings.

Expired Tokens Cleanup

 Removes expired tokens with elapsed expiration dates. agentcredential Daily, every six hours, starting at 00:00 h

ID Table Cleanup

 Removes IDs, used for filtering while working with user permissions and generating reports.

id_table

pv_id_table

Daily at 23:00 h

For instructions on how to schedule this job, see Configuring job scheduler settings.

Job Cleanup

Removes finished jobs. Failed jobs are removed after the set number of days, beginning with their start time. Canceled jobs are cleaned up without regard to start time.

 jobqueue Daily at 23:00 h

Orphaned Data Cleanup

 Removes metadata associated with attachments that are no longer needed. documentinfo Every Sunday at 23:30 h

Orphaned Source Files Cleanup

 Removes source files that are no longer referenced by any existing issue. sourcefile

Daily at 00:00 h

Set using job.sourceFileCleanup.cron

Report Cleanup

 Removes generated reports that are older than the number of days specified for Days to preserve on the Scheduler page.

savedreport

documentinfo

datablob

No cleanup scheduled

For instructions on how to schedule this job, see Configuring job scheduler settings.

Webhook History Cleanup

Removes old webhook event entries.

 webhookhistory Daily at 03:30 h

Index Maintenance

 Resolves inconsistencies between global search (fulltext) indexes and existing database entries. For example, resulting from unclean server shutdown or indexing job failures. N/A

Daily at 00:00 h

For instructions on how to schedule this job, see Configuring job scheduler settings.

LDAP Refresh

Updates caches associated with LDAP entities.

 N/A Every 6 hours

Historical Snapshot

Re-creates out-of-date snapshots.

 N/A

Daily at 00:00 h

For instructions on how to schedule this job, see Configuring job scheduler settings.

Alert Reminder

Sends reminder alerts.

 N/A Daily at 03:00 h

Token Expiry Alerts

Notifies users of any tokens to expire soon.

 N/A Daily at 03:00 h