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.
| Step | Description | Command |
|---|---|---|
| OptimizationJob | This step:
| exec dbo.ISHCore_OptimizationJob |
| TridkJob | This 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 |
| EventMonitorJob | This step removes the logging of successful background tasks older than a week. | exec dbo.ISHCore_RemoveEvents 7,'N','Y','N' |
| EventMonitorJob_RemoveFailedEvents | This step removes the logging of failed background tasks older than a month. | exec dbo.ISHCore_RemoveEvents 28,'Y','Y','Y' |
| CleanupSearchResults | This step cleans up the stored search results which are older than 3 days. | exec ISHCore_CleanupSearchResults 3 |
| CleanupBaselines | This step cleans up baselines that are not used by any publication object and are not modified in the last 7 days | exec ISHCore_CleanupBaselines 7 |
| RemoveRevisions | This step cleans up older revisions of objects that are out-of-date. | exec ISHCore_RemoveRevisions '5, 30' |