Documentation Center

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 jobParameters used by the job for this actionDefault value for this parameter (+ description)
Rebuild the indexes with a fragmentation > 10@ExecuteIndexMinimalMaintenanceY (values Yes/No)
Basic Content Manager Database Job
  • Cleaning up orphaned document components
  • Cleaning up objects marked for deletion
  • Correcting the value sequences (if necessary)
  • Correcting the rootword columns (if necessary)
--
Cleaning up successfully finished background tasks.@RemoveBackgroundTasksInDays1 (number of days after which the tasks will be cleaned)
Cleaning up failed background tasks@RemoveFailedBackgroundTasksInDays7 (number of days after which the tasks will be cleaned)
Cleaning up eventMonitor logging which is successfully finished or finished with warnings@RemoveEventsInDays7 (number of days after which the logs will be cleaned)
Cleaning up eventMonitor logging which is still busy@RemoveBusyEventsInDays28 (number of days after which the logs will be cleaned)
Cleaning up eventMonitor logging which finished with errors (= failed)@RemoveFailedEventsInDays28 (number of days after which the logs will be cleaned)
Cleaning up orphaned baselines@CleanupBaselinesInDays7 (number of days after which the baselines will be cleaned)
Cleaning up revisions@RemoveRevisionsForStatusTypes5 (Status type code for "out-of-date draft"), 30 (Status type code for "out-of-date")
Cleaning up session tokens@RemoveSessionSecurityTokensGraceDays20 (number of days after which the tokens will be cleaned)
Update the statistics of the user-tables (= execute sp_updatestats)@ExecuteIndexMinimalMaintenanceY (values Yes/No)