Documentation Center

Standard SQL Server Database Job

On SQL Server the standard SDL LiveContent Architect 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 job which runs daily and starts at 4 AM by default.

StepDescriptionCommand
OptimizationJobThis step:
  • updates statistics for all user tables
  • rebuilds indexes for all user tables
  • shrinks the database
exec dbo.ISHCore_OptimizationJob
TridkJobThis step is the basic SDL LiveContent Architect database job which cleans up orphaned document components and if necessary, corrects the value sequences.exec dbo.ComJob
EventMonitorJobThis step removes the logging of successful background tasks older than a week.exec dbo.ISHCore_RemoveEvents 7,'N','Y','N'
EventMonitorJob_RemoveFailedEventsThis step removes the logging of failed background tasks older than a month.exec dbo.ISHCore_RemoveEvents 28,'Y','Y','Y'
CleanupSearchResultsThis step cleans up the stored search results which are older than 3 days.exec ISHCore_CleanupSearchResults 3
CleanupBaselinesThis step cleans up baselines that are not used by any publication object and are not modified in the last 7 daysexec ISHCore_CleanupBaselines 7
RemoveRevisionsThis step cleans up older revisions of objects that are out-of-date.exec ISHCore_RemoveRevisions '5, 30'