Standard SQL Server Database Job
On SQL Server the standard Content Manager database job is one database job. The name of the job is the database name followed by "_StandardInfoShareJob".
The different actions are steps within the same executed procedure, named ISHCore_TrisoftInfoShareJob, which runs daily and starts at 4 AM by default.
Aspects of this job's behavior can be modified by changing the default values of the job's parameters.
| List of actions in the job | Parameters used by the job for this action | Default value for this parameter (+ description) |
|---|---|---|
| Rebuild the indexes with a fragmentation > 10 | @ExecuteIndexMinimalMaintenance | Y (values Yes/No) |
Basic Content Manager Database Job
| - | - |
| Cleaning up successfully finished background tasks. | @RemoveBackgroundTasksInDays | 1 (number of days after which the tasks will be cleaned) |
| Cleaning up failed background tasks | @RemoveFailedBackgroundTasksInDays | 7 (number of days after which the tasks will be cleaned) |
| Cleaning up eventMonitor logging which is successfully finished or finished with warnings | @RemoveEventsInDays | 7 (number of days after which the logs will be cleaned) |
| Cleaning up eventMonitor logging which is still busy | @RemoveBusyEventsInDays | 28 (number of days after which the logs will be cleaned) |
| Cleaning up eventMonitor logging which finished with errors (= failed) | @RemoveFailedEventsInDays | 28 (number of days after which the logs will be cleaned) |
| Cleaning up orphaned baselines | @CleanupBaselinesInDays | 7 (number of days after which the baselines will be cleaned) |
| Cleaning up revisions | @RemoveRevisionsForStatusTypes | 5 (Status type code for "out-of-date draft"), 30 (Status type code for "out-of-date") |
| Cleaning up session tokens | @RemoveSessionSecurityTokensGraceDays | 20 (number of days after which the tokens will be cleaned) |
| Update the statistics of the user-tables (= execute sp_updatestats) | @ExecuteIndexMinimalMaintenance | Y (values Yes/No) |